MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Silly time sum problem


Posted by Stephanie Bicknell on January 15, 2002 6:21 AM

I have a column that has time in it and would like to sum the column. When I do it I don't get the correct sum. WHat am I doing incorrectly? HELP!


Posted by Barrie Davidson on January 15, 2002 6:26 AM

What do you mean you don't get the correct sum? Perhaps it is how the cell is formatted. Try custom formatting the cell to:

[h]:mm

This will force the cell to display time as hours and minutes only.

Does this help?
BarrieBarrie Davidson

Posted by Michael on January 15, 2002 6:35 AM


A thought for you to consider.
1)Do you really want to sum the times in the column, or the differences between them (ie check in at 8:00 am, out at 12:00pm = 4 hours, but summed = 8:00 PM (12hours from the 8:00 AM)

Posted by Stephanie Bicknell on January 15, 2002 7:15 AM

Well, I have the in and out times and the difference. Now for each doctor I want to be able to sum how much time they have spent in the OR rooms. Hence, the sum of the difference of the in and out time... But when I sum the difference it doesn't give me the correct time. I am just confused. Why...

A thought for you to consider. 1)Do you really want to sum the times in the column, or the differences between them (ie check in at 8:00 am, out at 12:00pm = 4 hours, but summed = 8:00 PM (12hours from the 8:00 AM)

: I have a column that has time in it and would like to sum the column. When I do it I don't get the correct sum. WHat am I doing incorrectly? HELP!

Posted by Stephanie Bicknell on January 15, 2002 7:23 AM

The problem I'm having is the sum is great then 24 hours of course so I need to figure out what to use to get it to show me how many total hours... I guess maybe that is a better way of putting it... Sorry for the confusion... : : A thought for you to consider. : 1)Do you really want to sum the times in the column, or the differences between them (ie check in at 8:00 am, out at 12:00pm = 4 hours, but summed = 8:00 PM (12hours from the 8:00 AM) :


Posted by Barrie Davidson on January 15, 2002 8:39 AM

See my answer below (nt)


Posted by Stephanie Bicknell on January 16, 2002 7:53 AM

Re: See my answer below (nt)

Thanks a bunch Barrie. I should have read more. I was just so absent minded yesterday. You are great! I knew it had to be an easy one! I owe you...