| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i calculate the difference in time?
Thank you - this post really helped me
"JE McGimpsey" wrote: 1) XL stores times as fractional days. You can use the built-in TIME function: =IF(C1 < TIME(0,2,0), 1, 0) or just divide the number of hours by 24: =IF(C1 < 2/24, 1, 0) 2) Tools/Options/Edit check the Extend list formats as formulas checkbox (but read Help - there are limitations). Or you can do something like: =IF(C1="", "", IF(C1 < 2/24, 1, 0)) In article , "Roze" wrote: Just another little query, if i was doing the same spreadsheet but the reply email time limit was 2 hrs, how would i do that?? 2hr = 0, =<2hr= 1 And you know when you apply a formula to the spreadsheet, how can i have the column filled down with the formula, so i don't keep inserting it one by one?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
| calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
| How do you calculate the difference between two values within a p. | Excel Discussion (Misc queries) | |||
| What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel | |||
| Time / Formula to look at time difference | Excel Worksheet Functions | |||
Hybrid Mode
