Time convertion

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
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.
 
Back
Top