Thread: Calcualate Time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Calcualate Time


Assuming the data is in row 2.

Select all of column F and Using Number format set the following Custom
format for column F

[hh]"Hrs":mm"Mins"

Enter the following formula in cell F2
=(D2+E2)-(B2+C2)

--
Regards,

OssieMac