| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Problems calculating total hours
I am trying to create a wokr sheet that calculates the total hours worked in
a day utilizing hour:minute format. I've tried using =HOUR(B1-A1), and although the hours get added the minutes don't and I do need a formula that can calculate hour and minute and give me a total of how many there are in that work day. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MY VLOOKUP IS RETURNING N/A AND THEREFORE MY TOTAL SUM AT THE BOT. | Excel Discussion (Misc queries) | |||
| how to calculate total months from month/year | Excel Discussion (Misc queries) | |||
| how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
| Timesheet hours will not total. Help. | Excel Discussion (Misc queries) | |||
| Sumif or if statements-Help! | Excel Discussion (Misc queries) | |||
Threaded Mode
