Converting time h:m to amount of time h.h%

[Guest]

I need to convert time (3:15- 3 hours 15 min) to amount of time in hours
(3.25 hours)- what should I do?
Jenn

 

[Biff]

Hi!

Just multiply by 24.

=A1*24

Format the cell as GENERAL

Biff

 

[Ken Wright]

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------