| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
If the numbers are formatted as times, you can simply subtract them. The results will be in decimal hours, e.g. half an hour is .5 and 45 minutes is .75 hours. If you have to deal with third shift hours, where a shift ends "before" it begins, add 24 hours.
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel formula for an "if" "then" scenario linking 3 worksheets | Excel Discussion (Misc queries) | |||
| How do I write an excel formula with a text answer ("yes" or "no") | Excel Discussion (Misc queries) | |||
| Formula Result is "V6", need Excel to use cell "V6", not the resul | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Threaded Mode
