timesheet

[ML]

Hello
I'm trying to do a timesheet template to calculate time worked.
Managed to do the formula for the time worked from and to.
but for the life of me can't get the total to come out in Hours and Minutes.
Say I'm counting everyday 7.25 hours worked. I've formated the cells to be
hh:mm.The total comes up as 36.25 whereas it should be 37.15
Then when I change the cell where the total should be to hh:mm it becomes to
06:00. ???
That's by doing =C3+C4+C5+C6+C7
If I do =SUM(C3:C7) if come up with 00:00
Very confused as to why this should be so hard to do.
Please help.
Thank you

 

[Bob Phillips]

You are working in decimal not time, so a quarter of an hour is .25, as you
recognised by a day having 7.25 hours, not .15. So 36.15 is correct
..

It would be simpler to work with time and enter the day as 7:15 etc.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Niek Otten]

Look here:

http://www.cpearson.com/excel/datetime.htm#AddingTimes

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello
| I'm trying to do a timesheet template to calculate time worked.
| Managed to do the formula for the time worked from and to.
| but for the life of me can't get the total to come out in Hours and Minutes.
| Say I'm counting everyday 7.25 hours worked. I've formated the cells to be
| hh:mm.The total comes up as 36.25 whereas it should be 37.15
| Then when I change the cell where the total should be to hh:mm it becomes to
| 06:00. ???
| That's by doing =C3+C4+C5+C6+C7
| If I do =SUM(C3:C7) if come up with 00:00
| Very confused as to why this should be so hard to do.
| Please help.
| Thank you
|
|

 

[ML]

right but in this case it actually is 7 hours and 25 minutes and not 7 and
1/4.
so that should be 37 and 15 minutes which is 37hrs and 1/4.

 

[ML]

Wow just what I was looking for
Thank you.

 

[Bob Phillips]

So, still enter it as time and the sum will come out as 37:05

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)