Thread
:
Calcualate Time
View Single Post
#
2
Posted to microsoft.public.excel.newusers
OssieMac
external usenet poster
Posts: 2,510
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
Reply With Quote
OssieMac
View Public Profile
Find all posts by OssieMac