Board index MS EXCEL

How to convert an elapsed time in minutes to Days hours and minute

How to convert an elapsed time in minutes to Days hours and minute

Post by VGltZSBUcm » Mon, 10 Apr 2006 11:02:02


I would like to be able to convert a large number of minutes into days hours
and minutes (i.e 1550 minute= 1 day 1 hour 50 minutes).

Also I would to know how to calculate what time would 1 day 1 hour and 50
minutes be from a certian starting point.
 
 
 
Top

How to convert an elapsed time in minutes to Days hours and minute

Post by Peo Sjoblo » Mon, 10 Apr 2006 11:40:56

=A1/1440

custom format as d hh:mm

If you use real excel times then put 25:50 in a cell then just add it to
whatever time you start from



--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

 
 
 
Top

1. time elapsed in days hours minutes (unix to human readable form)

2. time elapsed in days hours minutes (unix to human readable form) - FIXED

3. Converting minutes to Days:Hours:Minutes

4. Converting Total Minutes into Days, Hours & Minutes

5. convert minutes to days,hours and minutes

6. converting minutes to DAYS /HOURS/ MINUTES -

7. Elapsed Days, Hours, and Minutes

8. Problem converting Hours to Days, Hours, Minutes

9. SQL 2005 Convert Hours to days:hours:minutes in one statement

10. Convert decimal days to Days,hours, minutes

11. Convert days in decimal to days:hours:minutes

12. Display Total Minutes in Days:Hours:Minutes

13. turning "1 day, 1 hour, 30 minutes" into 1530 minutes

14. format minutes to days hours & minutes

15. Formula for minutes to days:hours:minutes

All times are UTC
Board index