Thread: Calcualate Time
View Single Post
  #2  
Old April 11th, 2010, 08:57 AM posted to microsoft.public.excel.newusers
OssieMac
external usenet poster
  
Posts: 862
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