J
Jenn
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
(3.25 hours)- what should I do?
Jenn
B
Biff
Hi!
Just multiply by 24.
=A1*24
Format the cell as GENERAL
Biff
Just multiply by 24.
=A1*24
Format the cell as GENERAL
Biff
K
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
----------------------------------------------------------------------------
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------