LinkBack URL
About LinkBacks
Here's my normal shifts. how would i be able to add those times together to get the hours that i've worked, including my lunch, which is an hour.
06:00:00 AM
11:45:00 AM
12:45:00 PM
05:04:00 PM
Here's my normal shifts. how would i be able to add those times together to get the hours that i've worked, including my lunch, which is an hour.
06:00:00 AM
11:45:00 AM
12:45:00 PM
05:04:00 PM
Try
=((D1-A1+(D1<A1))-(C1-B1+(C1<B1)))*24
Where
A1 = Start
B1 = Lunch - Start
C1 = Lunch - Emd
D1 = End
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Good God, use MOD.....
=MOD(B1-A1,1)+MOD(D1-C1,1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks