| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
=MOD(C5-A5,1)
or less cryptic =C5-A5+(A5C5) Regards, Peo Sjoblom "dokliver" wrote: I am attempting to do a calculation for hours worked using the 24-hour format but have run into a problem. A simple minus calculation such as (C5-A5) does not yield an accurate calculation if the time value for A5 is greater than C5. Can you suggest a format/formula to use is my punch out time is 17:00pm and punch in time is 05:00am? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| elapsed time calculation | Excel Discussion (Misc queries) | |||
| entering numbers to display a time format | Excel Discussion (Misc queries) | |||
| "Manual calculation" takes less time. Why? | Excel Discussion (Misc queries) | |||
| Help - Information with time and date | Excel Discussion (Misc queries) | |||
| Excel - Time calculation | Excel Discussion (Misc queries) | |||
Threaded Mode
