Hello Rolf,
Can you plz put it in xls file?
Thanks
vr
On Fri, Nov 20, 2009 at 11:58 AM, RolfJ r...@pacificsound.us wrote:
This might work for you. Let's assume that the total numbers of
minutes is located in cell A2. The following formulae would calculate
the number of whole days, hours of
HI Rolf
I got it, Thank you.
On Fri, Nov 20, 2009 at 2:42 PM, vinod rao vinod.ma...@gmail.com wrote:
Hello Rolf,
Can you plz put it in xls file?
Thanks
vr
On Fri, Nov 20, 2009 at 11:58 AM, RolfJ r...@pacificsound.us wrote:
This might work for you. Let's assume that the total numbers of
This might work for you. Let's assume that the total numbers of
minutes is located in cell A2. The following formulae would calculate
the number of whole days, hours of next fractional day and minutes of
next fractional hour:
Number of days (Cell B2): =INT(A2/60/24) - 22 for your example
Hours