Time - converting HH:MM:SS to Minutes
 

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

You could use a helper cell with a formula:

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



Noel S Pamfree wrote:

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

--

Dave Peterson

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


"Dave Peterson" wrote in message
...
You could use a helper cell with a formula:

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



Noel S Pamfree wrote:

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

--

Dave Peterson

If you want to learn more about how excel treats dates and times, visit Chip
Pearson's site:

http://www.cpearson.com/excel/datetime.htm

Noel S Pamfree wrote:

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

"Dave Peterson" wrote in message
...
You could use a helper cell with a formula:

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



Noel S Pamfree wrote:

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

--

Dave Peterson

--

Dave Peterson