| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I make a change in time into a number I can use to calcula.
I am subtracting two times to get the difference, which I want to use in a
flow rate calculation, however, once I get the changes in time, I get an error in the cell used for calculations. It seems the time factor in the equation is throwing everything off. What I want to to is somehow use the change in time (5:00 am from 6:00 pm which should equal 13 and not 13:00) so it can be used in a formula |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I make a change in time into a number I can use to calcula.
=(endtime-StartTime)*24
or in the formula, multiply the cell by 24 -- Regards, Tom Ogilvy "Sportystan" wrote in message ... I am subtracting two times to get the difference, which I want to use in a flow rate calculation, however, once I get the changes in time, I get an error in the cell used for calculations. It seems the time factor in the equation is throwing everything off. What I want to to is somehow use the change in time (5:00 am from 6:00 pm which should equal 13 and not 13:00) so it can be used in a formula |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding descriptive text to formulas without interfering w/ calcula | Excel Discussion (Misc queries) | |||
| 28/10/2009 10:00 am calculate transit hours 75 hrs = total calcula | Excel Discussion (Misc queries) | |||
| Change time h:mm to a decimal number based on hours | Excel Worksheet Functions | |||
| Change Number to Time | Excel Discussion (Misc queries) | |||
| change time into simple number | Excel Worksheet Functions | |||
Linear Mode
