See your later posting. Please don't post the same question more than once.
--
David Biddulph

"srpavar" wrote in message
...
I have a time in A1 as 07:30AM as start time, B1 as 15:30PM as end time and
in C1 column I enter the actual time like 13:00PM, that means he goes
early
by 02:30hrs early than scheduled time or I enter 17:30PM in C1 column he
goes
by 02:00hrs late than scheduled time. can anyone help me to solve this
problem. Thanks in Advance