Hello peeps!
This is for a job sheet
I have a spreadsheet with 2 columns. The first column is start time the second column is stop time. The start time comes from the previous rows stop time value. so the values keep on increasing as you go down the rows, which is correct but unfortunatley i cannot get the time to stop / reset at 23:59hrs and change to time past midnight( 00:30hrs etc, which would be the following day)
Instead the numbers keep on climbing
I hope this makes sense!
Thanks in advance
Best regards
Yowge
This is for a job sheet
I have a spreadsheet with 2 columns. The first column is start time the second column is stop time. The start time comes from the previous rows stop time value. so the values keep on increasing as you go down the rows, which is correct but unfortunatley i cannot get the time to stop / reset at 23:59hrs and change to time past midnight( 00:30hrs etc, which would be the following day)
Instead the numbers keep on climbing
I hope this makes sense!
Thanks in advance
Best regards
Yowge