Excel formula for adding up sub-totals in time format

  • Thread starter Thread starter Nick T
  • Start date Start date
N

Nick T

I'm having trouble adding up all the sub-totals in my timesheet.

I have a number of sub-totals in h:mm format for each week of the month. I
used the AutoSum function to calculate each of these weekly sub-totals.

When I try to calculate my total hours for the month (i.e. add up all the
weekly sub-totals), I use the forumla: =SUM(C20,C35,C50,C57) . However, Excel
fails to add these up correctly - it simply reproduces the sub-total figure
at C20.

I've checked the fx field and the formula appears correctly. I've also made
sure all the time cells are in the same h:mm format.

Can anyone help me?!
 
Thank you Mike! Yes, the total does exceed 24 hours. I changed the format as
you suggested, and everything works perfectly now.

I'm very grateful for your help. :-)

Kind regards,
Nick in Sydney, Australia

Mike H said:
Hi,

If the total exceeds 24hrs you need a format of
[hh]:mm

Mike

Nick T said:
I'm having trouble adding up all the sub-totals in my timesheet.

I have a number of sub-totals in h:mm format for each week of the month. I
used the AutoSum function to calculate each of these weekly sub-totals.

When I try to calculate my total hours for the month (i.e. add up all the
weekly sub-totals), I use the forumla: =SUM(C20,C35,C50,C57) . However, Excel
fails to add these up correctly - it simply reproduces the sub-total figure
at C20.

I've checked the fx field and the formula appears correctly. I've also made
sure all the time cells are in the same h:mm format.

Can anyone help me?!
Click to expand...
Click to expand...
 
Back
Top