I currently use excel to track over 70 employees but I
need either a formula for the following scenrio.

In 7:45am out 12:00am in 1:25pm out 6:00pm then have a
total of hours in one cell for the whole day.

Right now I am enter the time but in military time.

I did find an excel template to use but the formla is not
right.