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

  • Thread starter Thread starter OB1
  • Start date Start date
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
 
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
 
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
 
You must log in or register to reply here.

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
days calculations 1
how to calculate productivity over hours spent 4
Help with a bsic formula 6
calculate hours just can't figure it out 1
Help please with formula 1
Excel won't update/calculate a single cell in a workbook 2

Back
Top