Converting time to numbers
 

In Excel I need to convert data entered as hours:minutes:seconds into minutes
only, i.e. 1:32:45 to 83.75 minutes. Any way to do this easily?

Hi
use
=A1*24*60
and format as number

--
Regards
Frank Kabel
Frankfurt, Germany
"DLSQestions" schrieb im Newsbeitrag
...
In Excel I need to convert data entered as hours:minutes:seconds into
minutes
only, i.e. 1:32:45 to 83.75 minutes. Any way to do this easily?

"DLSQestions" wrote in message
...
In Excel I need to convert data entered as hours:minutes:seconds into
minutes
only, i.e. 1:32:45 to 83.75 minutes. Any way to do this easily?

If the input is in a cell formatted as time, multiply by 24*60, and format
the answer as a number. Unfortunately the answer comes out as 92.75
minutes, rather than the 83.75 you wanted.
--
David Biddulph