Help! I am stuck calculating Days, Hours, Mins please help

O

OB1

Didn't have Toolpak installed on my system, and there are friends o
mine that haven't got it either so i have used the formulae provided b
Mr Harkawat and works.

I'd like to thank all of you for helping me.

OB
 
A

anilsolipuram

The formulae by Mr Harkawat is wrong, he didnot correctly use minute
and hours for calculating number of days.

modified formulae is


=(C5+INT((D5+(E5/60))/24))&" days "&MOD(D5,24)+MOD((INT(E5/60)),24)&
Hrs "&MOD(E5,60)&" Mins
 
N

N Harkawat

anilsolipuram
Using your formula for 0 days 5000 hrs and 61450 mins i get 251 days 24 Hrs
10 Mins instead of 251 Days 0 Hrs 10 Mins
N Harkawat
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help! I am stuck calculating Days, Hours, Mins please help 3
Help! I am stuck calculating Days, Hours, Mins please help 2
=SUM(IF help please 4
PC "gets stuck" entering Standby after SP2 installed 1
Windows XP Stuck on Loading Screen - Help! 4
Windows XP Stuck on Loading Screen - Help! 4
Excel Formula Help For Shift Pattern Indicator Table Please :O) 3
I AM NOT ABLE TO INSTALL VISTA, HELP !!! 1

Top