| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time function
I have a time in A1 as 07:30 AM as start time,
B1 as 15:30 PM as end time and in C1 column I enter the actual time like 13:00 PM, that means he goes early by 02:30hrs early than scheduled time or I enter 17:30 PM in C1 column if he goes by 02:00hrs late than scheduled time. i need a formula which give me a result in (-) or (+) in column D1 like -02:30hrs or 02:00hrs can anyone help me to solve this problem. Thanks in Advance for help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF function using TIME | Excel Discussion (Misc queries) | |||
| Time Function | Excel Worksheet Functions | |||
| verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
| Time function | Excel Worksheet Functions | |||
| Function to convert Time String to Time | Excel Worksheet Functions | |||
Threaded Mode
