Time Conversion

[Dastard]

Hi
well i want to calculate the number of minutes present in this time
(123:45:06 ) "123 hours , 45 minutes and 06 seconds"
this is time is in one cell .. i need a formula to put in another cell so that i can get the total number of minutes
Regards

[David Biddulph]

"Dastard" <Dastard.29m7sn_1150663201.5062@excelforum-nospam.com> wrote in
message news:Dastard.29m7sn_1150663201.5062@excelforum-nospam.com...
>
> Hi
> well i want to calculate the number of minutes present in this time
> (123:45:06 ) "123 hours , 45 minutes and 06 seconds"
> this is time is in one cell .. i need a formula to put in another cell
> so that i can get the total number of minutes

=A1*24*60
and format as number or general.
--
David Biddulph