Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to compare time in hh:mm format using IF function?
Sir,
This is a sample of worksheet. D 6 4:00 AM 7 11:00 AM And I have to subtract time using IF function and tried these syntexes =IF(D6<"8:00",("8:00"-D6), IF(D6"8:00 AM", (D6 - "8:00"), "OK")) and =IF(D6<"8:00", "LESS", IF(D6"8:00", "MORE", "OK")) and =IF(D6<"8:00",("8:00"-D6), (MOD(D6-"8:00",1))) But in all cases i found an error. I have to calculate the less time and over time by an employee. Please Suggest me. I have been tring it for 7-8days. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to compare time in hh:mm format using IF function?
Use
TIME(8,0,0) instead of "8:00" string! Regards, Stefi €˛Thanks€¯ ezt Ć*rta: Sir, This is a sample of worksheet. D 6 4:00 AM 7 11:00 AM And I have to subtract time using IF function and tried these syntexes =IF(D6<"8:00",("8:00"-D6), IF(D6"8:00 AM", (D6 - "8:00"), "OK")) and =IF(D6<"8:00", "LESS", IF(D6"8:00", "MORE", "OK")) and =IF(D6<"8:00",("8:00"-D6), (MOD(D6-"8:00",1))) But in all cases i found an error. I have to calculate the less time and over time by an employee. Please Suggest me. I have been tring it for 7-8days. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If statement to compare time cell to a time | Excel Worksheet Functions | |||
verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
Compare times : IF time < time2 then | Excel Worksheet Functions | |||
compare time | Excel Discussion (Misc queries) | |||
compare time in IF statement | Excel Worksheet Functions |