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" <ec35720@netscapeXSPAM.com> wrote in message
news:41E00104.62BAF861@netscapeXSPAM.com...
> 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" <ec35720@netscapeXSPAM.com> wrote in message
> news:41E00104.62BAF861@netscapeXSPAM.com...
> > 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