Convert Time: HH:MM to HH and tenths of hours

[mdalby]

Is there a way to convert time that is 1:50 (1 hour and 50 minutes) t
1.833 hours?

I can do a text to columns and split up the hours into one column an
have the minutes in another column and do algegra to get the result
but the data is in a format that it would be difficult to use thi
approach. I am hoping for a formula to get the desired results.

Thanks in advance.

M

 

[Peo Sjoblom]

Multiply by 24 and format as general, if you want to convert in place,
format a cell as general, put 24 in it, copy it, select the times you want
to convert
and do edit>paste special and check multiply. Or if you are trying to
calculate cost
per hour just use =time*24*rate. I would personally use a formula, that way
I would have an
audit trail if I need to..

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Jason Morin]

=A1*24

HTH
Jason
Atlanta, GA

 

[Alan]

Format the cell as [hh]:mm and multiply by 24
Note that the result cell will default to the same format and show 44:00
Format it as general and it will show 1.833333
Regards,