Converting time to numbers

G

Guest

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?
 
D

David Biddulph

DLSQestions said:
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?
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting minutes to tenths 2
Converting hours:minutes:seconds to just minutes 3
Quarter Hour time conversions for timesheet 2
excel formula 1
Time Fomat 3
CONVERTING MINUTES AND SECONDS TO MINUTES ONLY 3
Accumulating elapsed times. 3
convert minutes and seconds (in a date format) to numbers 6

Top