|
|
#1
01-14-2010, 04:01 PM
|
|||
|
|||
Can I do calculations with times?
I am doing an employee check in sheet. I want to enter the time an employee finishes for the day, compare that time to quitting time and display the amount of overtime worked if any. =IF(cell>6:30,cell-6:30,0) is what I am trying to use. Time isn't a valid value though.
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Copying page 1 800 times
|
echomakr | Word | 1 | 09-11-2009 08:00 AM |
| Calendar Events Repeated Many Times | johnmacek | Outlook | 0 | 08-21-2009 04:43 PM |
| Outlook sends same message multiple times | dikob | Outlook | 4 | 01-19-2009 12:13 PM |
|
Mail Times Wrong
|
bshow | Outlook | 1 | 01-17-2007 02:45 PM |
|
Having problems with Duration calculations.
|
bgane | Project | 1 | 03-20-2006 06:36 AM |
Windows XP 
Office 2003
Threaded Mode