LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Turning numbers into days, hours and minutes

Hello,

To keep it short and simple:

I have 4220 lbs of grain and I can only unload 2000 lbs a day. I divide the
number and end up with 2,1100 work days. How is it possible to have excel
write the days, hours and minutes as I can only get it to write the hours and
minutes used. 4220/2000 = 2,11 days = 02h:38m:24s. The time spend is the
same if I only write ,11.. Is it even possible for Excel to do this? Or am I
supposed to just write the days in myself and let excel do the rest???
 
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
converting days, hours and minutes to minutes wowo35 New Users to Excel 1 June 15th 08 07:00 AM
converting Days Hours & minutes into just minutes in excel Six Sigma Blackbelt Excel Discussion (Misc queries) 5 April 28th 06 09:45 PM
Convert days in decimal to days:hours:minutes Todd F. Excel Worksheet Functions 7 March 16th 06 07:17 PM
Problem converting Hours to Days, Hours, Minutes Zyzzx Excel Worksheet Functions 4 October 24th 05 04:19 PM
Formula for minutes to days:hours:minutes QueenCutieT Excel Discussion (Misc queries) 2 February 10th 05 12:30 AM


All times are GMT +1. The time now is 12:43 PM.

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

About Us

"It's about Microsoft Excel"