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

[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

[Biff]

Hi!

Just multiply by 24.

=A1*24

Format the cell as GENERAL

Biff

"Jenn" <Jenn@discussions.microsoft.com> wrote in message
news:FDA503A6-B164-4AD1-AA6D-4CFE15F49DF0@microsoft.com...
>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

[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 :-)
------------------------------*------------------------------*----------------


"Jenn" <Jenn@discussions.microsoft.com> wrote in message
news:FDA503A6-B164-4AD1-AA6D-4CFE15F49DF0@microsoft.com...
>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