| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
perform calculations using time arguments
How to perform calculations using time as arguments?
E.g. "F1-F2" works fine where both cells contain values with (h:mm) format, but "F1-8:00" returns an error. Also, when using =IF(), when [value_if_true] is "f1-8:00" I get a formula error. what up? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
perform calculations using time arguments
Hi Derek
Try F1-TIME(8,0,0) -- Regards Roger Govier "Derek" wrote in message ... How to perform calculations using time as arguments? E.g. "F1-F2" works fine where both cells contain values with (h:mm) format, but "F1-8:00" returns an error. Also, when using =IF(), when [value_if_true] is "f1-8:00" I get a formula error. what up? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
perform calculations using time arguments
-- Dale H. "Derek" wrote: How to perform calculations using time as arguments? E.g. "F1-F2" works fine where both cells contain values with (h:mm) format, but "F1-8:00" returns an error. Also, when using =IF(), when [value_if_true] is "f1-8:00" I get a formula error. what up? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculations from date and time values | Excel Worksheet Functions | |||
| Please help with Time calculations | Excel Discussion (Misc queries) | |||
| Time Calculations | Excel Worksheet Functions | |||
| time interval calculations in excel | Excel Discussion (Misc queries) | |||
| Best technique to perform multiple calculations ? | Excel Worksheet Functions | |||
Linear Mode
