Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Time Formula
How do I convert a time formula from actual minutes to a decimal (100 units
per hour)? Example using military time: 13:00 - 8:30 = 4 hours 30 minutes OR 4.50 |
#2
|
|||
|
|||
Just multiply the result by 24 (hours in a day)
=C1*24 -- HTH RP (remove nothere from the email address if mailing direct) "mbranstrator" wrote in message ... How do I convert a time formula from actual minutes to a decimal (100 units per hour)? Example using military time: 13:00 - 8:30 = 4 hours 30 minutes OR 4.50 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Formula for time | Excel Discussion (Misc queries) | |||
Formula for time? | Excel Discussion (Misc queries) | |||
What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel | |||
Finding last cell to contain same value as current cell? | Excel Worksheet Functions |