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.