Remember Me?

#1
January 8th 05, 03:45 PM
 Noel S Pamfree Posts: n/a
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

#2
January 8th 05, 03:49 PM
 Dave Peterson Posts: n/a

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
#3
January 8th 05, 04:01 PM
 Noel S Pamfree Posts: n/a

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

#4
January 8th 05, 04:26 PM
 Dave Peterson Posts: n/a

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Randberger Excel Discussion (Misc queries) 4 January 19th 05 08:49 PM Rachael Excel Worksheet Functions 1 January 6th 05 10:01 PM Jack Cutrone Excel Discussion (Misc queries) 7 December 27th 04 11:23 PM Patricio Boric Excel Worksheet Functions 1 November 28th 04 07:43 PM MarianneR Excel Worksheet Functions 4 November 18th 04 03:24 PM

All times are GMT +1. The time now is 11:13 PM.