What formula would I use to calculate the difference in time for same cell.
A1: 7am-3pm
B1: 7am-3pm
C1: 1pm-6pm
D1: 3pm-11pm
E1: 3pm-7pm
F1: OFF
G1: OFF
H1: Total hours scheduled to work
What formula would I use to calculate the difference in time for same cell.
A1: 7am-3pm
B1: 7am-3pm
C1: 1pm-6pm
D1: 3pm-11pm
E1: 3pm-7pm
F1: OFF
G1: OFF
H1: Total hours scheduled to work
Wow.....You really didn't do yourself any favors by allowing inconsistencies in the data! You've got am's and pm's with and without preceding spaces.
Note_1: Format B1 as TimePlease Login or Register to view this content.
Note_2: there are some spaces in that formula, but ONLY within quotes AND preceeding an "a" and a "p".....so be careful.
If there was some control over the input, for example if each cell followed this pattern:
hh am/pm-hh am/pm
Example: 07 am-11 pm
Does that help?Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks