RollieMillan
New Member
- Joined
- Mar 23, 2016
- Messages
- 2
Hi, I'm trying to find a formula that will add different times but ignore cells when text instead of time is typed on the cell. Here is an example of what I'm trying to do and the formula I'm currently using (which works until text is replacing time):
[K] [L] [N] [O] [Q] [R] [T] [W] [X] [Z]
MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY TOTAL HRS
In Out In Out In Out In Out In Out
5:00 AM 2:00 PM 5:00 AM 12:00 PM 5:00 AM 4:00 PM OFF OFF 5:00 AM 1:30 PM _________
Formula used: =SUM((L3-K3)*24)+((O3-N3)*24)+((R3-Q3)*24)+((U3-T3)*24)+((X3-W3)*24)
I was privileged to keep track of the times and days off of 500+ employees, so I'm trying to make my life as easy as possible. Thank you in advance for your help.
[K] [L] [N] [O] [Q] [R] [T] [W] [X] [Z]
MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY TOTAL HRS
In Out In Out In Out In Out In Out
5:00 AM 2:00 PM 5:00 AM 12:00 PM 5:00 AM 4:00 PM OFF OFF 5:00 AM 1:30 PM _________
Formula used: =SUM((L3-K3)*24)+((O3-N3)*24)+((R3-Q3)*24)+((U3-T3)*24)+((X3-W3)*24)
I was privileged to keep track of the times and days off of 500+ employees, so I'm trying to make my life as easy as possible. Thank you in advance for your help.