Hi,
I am currently working with some data that include columns with start and end time of bus trips. The time-stamps don't come in a time cell format but rather in a general one.
The problem is I cannot simply subtract those timestamps as sometimes the end date is on the next day and there is no full date data included, it is just the timestamps.
I tried several things, with mixed results. For example I made an if function where in case "B (end time) < A (start time)" then "24+B-A" if not "B-A". The problem with this approach is that it treats the time-stamps as numbers and whereas for "o'clock" ones is totally fine, that is not the case where minutes are involved. Changing the cell format to date, solves the minutes problem but adds another since time is a 24 system which renders the formula above as simply useless.
Any input would be appreciated.
Bookmarks