Hi, Newbie here.
I have seen some other threads on this, but didn't want to ask in those...
I have been entering some backup times using 24 hr clock, and manually entering the colon, example:
B2 22:10 C2 22:50 with results in D2 0:40
But now I have a project that I will be entering about 100 of these a day ( 24 hour format) And I would like not to have to put in the colon.
In other threads I found the use of Custom 0\:00 format allows me not to enter the colon. cool/ but I am no longer getting correct results in D2
A few of these times will go over the midnight mark, so results would have to calculate that also.
I hope I explained this correctly.
Bookmarks