Working on a spreadsheet to calculate on-time performance. I have a set time for a daily arrival and cells for the actual arrival each day.
EXAMPLE:
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
The formula i'm using to calculate the "Minutes Late/Early" for each day is =IF(B4-C4<0, "-" & TEXT(ABS(B4-C4),"hh:mm"), B4-C4) My issue is adding the negative times in Column "L".
Any ideas so it will add the negative times and display a negative percentage?
EXAMPLE:
A B | C D | E | F | G | H | I | J | K | L | M |
<tbody>
</tbody>
SCHEDULED PICKUP TIME | MONDAY | MINUTES LATE/EARLY | TUESDAY | MINUTES LATE/EARLY | WEDNESDAY | MINUTES LATE/EARLY | THURSDAY | MINUTES LATE/EARLY | FRIDAY | MINUTES LATE/EARLY | WEEK PERCENTAGE LATE/EARLY | WEEKLY ONTIME PERFORMANCE |
<tbody>
</tbody>
7:30:00 AM | 8:00:00 AM | -00:30 | 8:00:00 AM | -00:30 | 8:00:00 AM | -00:30 | 8:00:00 AM | -00:30 | 8:00:00 AM | -00:30 | 0:00 | 100.00% |
<tbody>
</tbody>
The formula i'm using to calculate the "Minutes Late/Early" for each day is =IF(B4-C4<0, "-" & TEXT(ABS(B4-C4),"hh:mm"), B4-C4) My issue is adding the negative times in Column "L".
Any ideas so it will add the negative times and display a negative percentage?