Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time
How can I subtract two cells that have a 12-hour time format and return a
value of toal hours within this range in decimal form such as 8.3 hours? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time
You simply have to subtract the tow numbers =A1-B1. but there are two caveots
1) the resulting cell has to be formated as a number not as time. the reusults is not a serial time number in excel 2) the difference is a fraction of a day where 1 equals 24 hours. To get hours simply multiply by 24. example 11:00 - 3:00 = .333333 (8 / 24) 24 * .3333333 = 24 * 8/24 = 8.0 "Troy2006" wrote: How can I subtract two cells that have a 12-hour time format and return a value of toal hours within this range in decimal form such as 8.3 hours? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time
Try this:
=MOD(B1-A1,1)*24 Format as GENERAL or NUMBER -- Biff Microsoft Excel MVP "Troy2006" wrote in message ... How can I subtract two cells that have a 12-hour time format and return a value of toal hours within this range in decimal form such as 8.3 hours? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time
Times are stored as fractional days, so the display format doesn't
matter in calculations. That also means to convert times to integer hours, multiply by 24. One way: =ROUND(MOD(B1-A1,1)*24,1) In article , Troy2006 wrote: How can I subtract two cells that have a 12-hour time format and return a value of toal hours within this range in decimal form such as 8.3 hours? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting date/time serial values to cumulative time totals... | Excel Discussion (Misc queries) | |||
verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
template or formula for start time -finish time -total hours ple | New Users to Excel | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions |