Formula minutes and seconds

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I change the following:
The cell reads: 14:42:0 for minutes and seconds.
I need to convert cell to 14.7
 
Are you sure this is not hours:minutes:seconds? Usually you would have
14:42.0 if this stood for 14 minutes and 42 seconds (with no tenths of
a second), but the way you have typed it it looks like 14 hours and 42
minutes.

If it does stand for hh:mm:ss and you want the number of hours, then
just multiply it by 24 and format the cell as a number with 1 decimal
place. If it stands for mm:ss:tt with hours not displayed, then you
will need to multiply by 24 and by 60 to convert it to decimal
minutes.

Hope this helps.

Pete
 
You must log in or register to reply here.

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

convert decimal figure to minutes and seconds 3
Convert time in cell 2
Formating seconds into mm:ss 4
Converting time 3
Strange Cell Format Behavior 6
Public Function Remarks 2
Create a custom format to convert seconds to minutes. 3
hh:mm:ss keeps converting to a date 4

Back
Top