Total Hours

[Floyd Forbes]

Is there a way in excel to convert total hours. I'm trying to
convert 8:07 to 8:25, 8:23 to 8:50, 8:37 to 8:45 and 8:55 to 9:00.
Is this possible to do in excel.

Floyd

 

[J.E. McGimpsey]

I'm sure it's possible, but I see no rhyme or reason for the
"conversions" you're making. Do the converted values remain XL
times? If so, why would 8:23 convert to 8:50, but 8:37 convert to
8:45?

Please explain.

 

[Nick Hodge]

Floyd

I am sorry, but I do not understand the correlation between the numbers.
Maybe it's just me.

If you can post back with a more detailed explanation, someone will take a
look I'm sure.

It may also help you to understand how XL stores dates and times. (You ,ay
then be able to figure it out yourself). Take a look at

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)