DUMBASS
New Member
- Joined
- Oct 12, 2007
- Messages
- 14
Hi
I know I've asked this before and got a solution but need to resolve the issue again so please bear with me.
I'm running a 24 hour delivery schedule where i need to work out the time difference between start & finish times.
I'm OK until I get to cross midnight range:
A1 Start 19:00
B1 Finish 18:45
C1 +/- 00:15
(happy days and will return negative value if later)
A1 Start 00:15
B1 Finish 23:45 (earlier)
C1 +/- -23:30
(headache)
I know I can modify the formula in C1 for example 2 but schedule changes daily and column ranges from A1 to A300+
so... is there 1 formula I can use for the full column range to return the right result as this is a multi user form and I'm not always there to do the modification.
I know I've asked this before and got a solution but need to resolve the issue again so please bear with me.
I'm running a 24 hour delivery schedule where i need to work out the time difference between start & finish times.
I'm OK until I get to cross midnight range:
A1 Start 19:00
B1 Finish 18:45
C1 +/- 00:15
(happy days and will return negative value if later)
A1 Start 00:15
B1 Finish 23:45 (earlier)
C1 +/- -23:30
(headache)
I know I can modify the formula in C1 for example 2 but schedule changes daily and column ranges from A1 to A300+
so... is there 1 formula I can use for the full column range to return the right result as this is a multi user form and I'm not always there to do the modification.