Re: Time Conversion

Giganews Newsgroups
Subject: Re: Time Conversion
Posted by:  David Biddulph (dav…@biddulph.org.uk)
Date: Sun, 18 Jun 2006

"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

Replies

None

In response to

Time Conversion posted by Dastard on Sun, 18 Jun 2006