Thread
:
Calcualate Time
View Single Post
#
2
April 11th, 2010, 08:57 AM posted to microsoft.public.excel.newusers
OssieMac
external usenet poster
Posts: 862
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
OssieMac
View Public Profile
View message headers
Find all posts by OssieMac
Find all threads started by OssieMac