I am working with hours difference split between two days. i.e start work at 23:00 on 1st and finish at 07:00 on the second.
Now when it comes for easier typing of the hours I format the cell for CUSTOM 00\:00 so I can type the hours and minutes continuously and the format takes care of placing the colon , that works fine as a format but doesn't return the same result compared to typing the hours the traditional way with the colon inserted manually.
I am after using the format for easier typing and getting the correct result.
Thanks in advance
Image 1.png
Bookmarks