Time - converting HH:MM:SS to Minutes


N

Noel S Pamfree

Is there a way I can use a time entered in a cell in the format hh:mm:ss and
convert it into a decimal of minutes?

I have tried using the 'Time' function but can only get it to work if I
enter each of the three parts in separate columns.

Thanks

Noel
 
Ad

Advertisements

D

Dave Peterson

You could use a helper cell with a formula:

=A1*24*60
(Format it as general, though)
 
N

Noel S Pamfree

That is an amazing trick Dave, worked first time - Thanks!
 
Ad

Advertisements


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

Top