Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Helping someone out with a worksheet that figures time (in military
time) for use at weekend race tracks. Generally they have two days so it was easy with 2 IN's/2 OUT's for each day. But the rain at Daytona this weekend created a problem we did not expect. Someone starts work at Sat 0630 and finishes at 0130 Sun. Morning. Excel is not giving the total in correct hours, but I realize that's it's because you've gone to another day. As a workaround I told them for now to enter it as 2 days 0630 to 2400 and 0000 to 0130....is there a more elegant (or right) way to accomplish this? David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
Time - Hours and Minutes | Excel Discussion (Misc queries) | |||
calculate difference in time to hours | Excel Worksheet Functions | |||
in excel totaling weekly hours military time | Excel Worksheet Functions | |||
How do I convert Military Time to minutes? | Excel Worksheet Functions |