If you insist on using your original formula, try a more lengthier
*=QUOTIENT(G91,1)*1440+HOUR(**G9**1)*60+MINUTE(**G9**1)+SECOND(**G9**1)/60*
But *=G91*1440 will give the same answer*
Regards,
Sam Mathai Chacko
On Fri, Feb 24, 2012 at 10:19 PM, Sam Mathai Chacko wrote:
> *=G91*1440*
>
> Regar
*=G91*1440*
Regards,
Sam Mathai Chacko
On Fri, Feb 24, 2012 at 4:53 PM, satish
wrote:
> Hi all,
>
> I have the data in below format, I try to convert the date format in
> to decimal Minutes. It comes well when the data below 24 Hrs, as soon
> as it exceed 24 Hrs, it gives a wrong fig.
>
> I u
Hi all,
I have the data in below format, I try to convert the date format in
to decimal Minutes. It comes well when the data below 24 Hrs, as soon
as it exceed 24 Hrs, it gives a wrong fig.
I used the below formula to get answers
=HOUR(G91)*60+MINUTE(G91)+SECOND(G91)/60
gprs - national -
