Time convertion

[John]

Hi Folks,
I need to convert a time value which appers as hh:mm:ss to
minuets so that it appears in a decimal format.......eg.1:30.30 appears as
60.55. Does anyone have an idea of how I might do this. Its for analysing
phone usage. Thanks in advance.....John

 

[Norman Harker]

Hi John!

To convert a time in A1 to minutes use:

=A1*(24*60)

But 1:30.3 in A1 will give you 1.505 minutes.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[John]

Cheers Norman........I will test it out later.
John