S
srpavar
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.
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.