Getting a total of hours & mins worked per week

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

big_weegie - 16 Jun 2005 23:20 GMT

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 to this Message

JE McGimpsey - 16 Jun 2005 23:44 GMT

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

> 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
[quoted text clipped - 4 lines]
>
> thanks

Reply to this Message