Thread: Time functions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
srpavar srpavar is offline
external usenet poster
 
Posts: 11
Default Time functions

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