| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timesheet hours format not adding
I have a timesheet with a column for TOTAL APPROVED HOURS (a SUM of manually
entered approved hours formatted as Number) and TOTAL WORKED HOURS (a sum of the hours Mon - Fri formatted as H:MM). Because of the formats, the hours are adding, but giving different values. Dont know how to explain it all b/c there are formuals involved. Any Excel expert willing to look at my sheet (confidential info removed of course) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding time in 24 hour format to produce hours in decimal format | Excel Worksheet Functions | |||
| how do i add hours on a timesheet? | Excel Worksheet Functions | |||
| timesheet - excess hours | Excel Discussion (Misc queries) | |||
| Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
| Timesheet hours will not total. Help. | Excel Discussion (Misc queries) | |||
Threaded Mode
