Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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??? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning numbers into days, hours and minutes
Custom format the cell where your answer is as dd:hh:mm:ss
Nymand wrote: 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??? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning numbers into days, hours and minutes
I would use d "days" h:mm:ss, but beware, this only works up to 31 days.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Alan" wrote in message oups.com... Custom format the cell where your answer is as dd:hh:mm:ss Nymand wrote: 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??? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning numbers into days, hours and minutes
Hello,
I'm not exactly sure what you and Alan mean! The "box" with the result. Am I supposed to right-click and find what I'm looking for there? I'm not sure I know how to custom format the cell. I can't seem to find both the days and the hours used.. "Bob Phillips" skrev: I would use d "days" h:mm:ss, but beware, this only works up to 31 days. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Alan" wrote in message oups.com... Custom format the cell where your answer is as dd:hh:mm:ss Nymand wrote: 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??? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning numbers into days, hours and minutes
In the 'cell' that the result is in (=4220/2000 or maybe =A1/B1), select
that cell, got to menu FormatCellsCustom, and add one of the formats we gave. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Nymand" wrote in message ... Hello, I'm not exactly sure what you and Alan mean! The "box" with the result. Am I supposed to right-click and find what I'm looking for there? I'm not sure I know how to custom format the cell. I can't seem to find both the days and the hours used.. "Bob Phillips" skrev: I would use d "days" h:mm:ss, but beware, this only works up to 31 days. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Alan" wrote in message oups.com... Custom format the cell where your answer is as dd:hh:mm:ss Nymand wrote: 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??? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning numbers into days, hours and minutes
So far so good, I found the place because of you guys,but I can't seem to use
both days and hours.. If I use one of them, I end up with this result: 02:h:38:24. Now I only need to have 2 written where the "h" is.. "Bob Phillips" skrev: In the 'cell' that the result is in (=4220/2000 or maybe =A1/B1), select that cell, got to menu FormatCellsCustom, and add one of the formats we gave. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Nymand" wrote in message ... Hello, I'm not exactly sure what you and Alan mean! The "box" with the result. Am I supposed to right-click and find what I'm looking for there? I'm not sure I know how to custom format the cell. I can't seem to find both the days and the hours used.. "Bob Phillips" skrev: I would use d "days" h:mm:ss, but beware, this only works up to 31 days. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Alan" wrote in message oups.com... Custom format the cell where your answer is as dd:hh:mm:ss Nymand wrote: 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??? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning numbers into days, hours and minutes
You have entered an incorrect format then, there should be no h.
Try again with d "days" h:mm:ss including the " -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Nymand" wrote in message ... So far so good, I found the place because of you guys,but I can't seem to use both days and hours.. If I use one of them, I end up with this result: 02:h:38:24. Now I only need to have 2 written where the "h" is.. "Bob Phillips" skrev: In the 'cell' that the result is in (=4220/2000 or maybe =A1/B1), select that cell, got to menu FormatCellsCustom, and add one of the formats we gave. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Nymand" wrote in message ... Hello, I'm not exactly sure what you and Alan mean! The "box" with the result. Am I supposed to right-click and find what I'm looking for there? I'm not sure I know how to custom format the cell. I can't seem to find both the days and the hours used.. "Bob Phillips" skrev: I would use d "days" h:mm:ss, but beware, this only works up to 31 days. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Alan" wrote in message oups.com... Custom format the cell where your answer is as dd:hh:mm:ss Nymand wrote: 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??? |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning numbers into days, hours and minutes
2 days hh:38:24 This is actually what I can come up with.. Guess it's a
step further. Whether I make it with one H or two doesn't make a difference.. Could you please write exactly what I need to write. Word for word... and nothing else.. Don't know if that'll help me but guess that's all I can manage.. "Bob Phillips" skrev: You have entered an incorrect format then, there should be no h. Try again with d "days" h:mm:ss including the " -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Nymand" wrote in message ... So far so good, I found the place because of you guys,but I can't seem to use both days and hours.. If I use one of them, I end up with this result: 02:h:38:24. Now I only need to have 2 written where the "h" is.. "Bob Phillips" skrev: In the 'cell' that the result is in (=4220/2000 or maybe =A1/B1), select that cell, got to menu FormatCellsCustom, and add one of the formats we gave. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Nymand" wrote in message ... Hello, I'm not exactly sure what you and Alan mean! The "box" with the result. Am I supposed to right-click and find what I'm looking for there? I'm not sure I know how to custom format the cell. I can't seem to find both the days and the hours used.. "Bob Phillips" skrev: I would use d "days" h:mm:ss, but beware, this only works up to 31 days. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Alan" wrote in message oups.com... Custom format the cell where your answer is as dd:hh:mm:ss Nymand wrote: 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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting days, hours and minutes to minutes | New Users to Excel | |||
converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) | |||
Convert days in decimal to days:hours:minutes | Excel Worksheet Functions | |||
Problem converting Hours to Days, Hours, Minutes | Excel Worksheet Functions | |||
Formula for minutes to days:hours:minutes | Excel Discussion (Misc queries) |