Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Getting a total of hours & mins worked per week
I am trying to make a spreadsheet of the daily hours worked and a total of
the weekly hours but i am not having any luck, at the moment I have the following H3 08:33, H4 08:01, H5 07:23, H6 08:15, H7 08:15, when i type =sum(h3:h7) i get 16:27 instead of 40:27 i would appreciate any advice thanks |
#2
|
|||
|
|||
XL stores times as fractional days (e.g., 3:00 = 0.125). The default
time display "rolls over" every 24 hours. To keep that from happening, use brackets in your format: Format/Cells/Number/Custom [h]:mm In article , "big_weegie" wrote: I am trying to make a spreadsheet of the daily hours worked and a total of the weekly hours but i am not having any luck, at the moment I have the following H3 08:33, H4 08:01, H5 07:23, H6 08:15, H7 08:15, when i type =sum(h3:h7) i get 16:27 instead of 40:27 i would appreciate any advice thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel needs hh:mm where hh>24 for hours worked per week | Excel Worksheet Functions | |||
Calculating Overtime from Hours total | Excel Worksheet Functions | |||
How can I make an Employment Schedule that Tabulates hours worked. | Excel Worksheet Functions | |||
calculate average hours worked | Excel Worksheet Functions | |||
Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions |