missyvette
New Member
- Joined
- Jul 24, 2010
- Messages
- 11
I have a spreadsheet that shows what date and time a job was submitted and the time that it is due. I would like to have a status field that uses the red circle x and green check mark icons to appear in the status field. I want a red circle if it is late, a yellow symbol if it is due within 60 minutes and the green check mark when we have 120 minutes or more left to complete the job.
My date and time field is formatted with the date format: 3/14/01 1:30 PM so that we can use the NOW function.
How do I write this function?
My date and time field is formatted with the date format: 3/14/01 1:30 PM so that we can use the NOW function.
How do I write this function?