View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RKS RKS is offline
external usenet poster
 
Posts: 63
Default time calculation

Sir,

Pl help me calculate the hours. I have two col A & B
A B C
Time In Time Out Working Days

17:00 ( 5pm) 02:00 a.m. (Next Days) = 9 hours
17:00 15:00 p.m. (next days) = 22 hpurs

how i can apply formula.

RKS