LinkBack URL
About LinkBacks
Im trying to convert hours to date. If I have 47 hours left for a cylinder to fill, what is this date; in months, days, hours, and minutes that it will fill.
Im trying to convert hours to date. If I have 47 hours left for a cylinder to fill, what is this date; in months, days, hours, and minutes that it will fill.
It depends on the hour, minute and date when the cylinder started to fill
If you found the solution to your question. Mark the thread as "Solved"
Thank everyone that helped you with a valid solution by clicking on their
There is no such thing as a problem, only a temporary lack of a solution
If cylinder fill max is 2000kg and filling at 5 kg/hr this will take 400 hrs to fill. how can i change this 400 hours (16.67 days) to the exact date and time it will fill.
You will need the starting date and time in question.
For testing:
In A1 specify the time. Use the =now() formula for example, format the cell to date with time option
In B1 insert =A1+47/24 (format in Date with time option)
in a cell in Excel, if you were to enter the Date and Time the filling started, then in an adjacent cell if you entered "400:00:00", then in an adjacent cell if you were to add these two values, Excel will automatically tell you the time at which filling will complete. Excel treats Dates and Time (if entered properly) just like regular numbers (in reality, they are just that).
for example, enter "28-03-2013 09:50:00 PM" (without the quotes) in A1. in A2, enter "400:00:00" (without quotes). then, in A3, enter the formula:
it will display "14-04-13 13:50", which is exactly 16.667 days (16 days and 16 hours) from "28-03-2013 09:50:00 PM".
Please Login or Register to view this content.
another way would be to just add the two in this format - if A1 contained current date and time, then in A3:
=A1+"400:00"
does that help?
Last edited by icestationzbra; 03-28-2013 at 10:31 PM.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
This takes the hours that you enter and converts them to Months, Day, Hour, Minutes and takes into account for leap year.
Yes it will. we just have to figure out how...
If I have helped you, PLEASE click the * and add to my Rep.
Also, if the problem is SOLVED please mark it as so.
I just tried it and it is giving me an "#value! error
How would I enter this using the now formula
See attached
A2 has the Now formula. You can change to a specific one
how can I convert this 16 days, 16 hrs, 15 mins to the date it will fill. So if it fills in 16 days I would like it to read something like April 13 at 9pm.
Thanks I think I got it!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks