Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Time Tracker
 
Posts: n/a
Default How to convert an elapsed time in minutes to Days hours and minute

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default How to convert an elapsed time in minutes to Days hours and minute

=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




"Time Tracker" <Time wrote in message
...
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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding hours and minutes Patrick Excel Worksheet Functions 16 June 18th 08 09:24 PM
Need to convert hours and minutes to hours and tenths. MikeC Excel Discussion (Misc queries) 2 February 9th 06 07:22 PM
calculate elapsed time between dates and times Jenna Excel Worksheet Functions 2 January 25th 06 05:39 PM
i need to convert seconds (ie: 17288.35111) into days, hours, min jriechers Excel Discussion (Misc queries) 1 September 27th 05 10:06 PM
Timecards, hours & minutes Dixie Excel Worksheet Functions 1 August 31st 05 03:10 PM


All times are GMT +1. The time now is 02:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"