I am trying to set up a spread sheet to calculate a premium wage (extra $0.25) for employees who work Midnight to 6am.

I have to keep it simple on the inputting side of things and would like the format to be:

Start Time | Finish Time | Regular Hours | Premium Hours

This can be used to pull the time range data:

00:00:00 | 06:00:00

What I need is a function that will sum both regular and premium hours, and separate them in different cell's.

I have tried a couple IF statements, and just can't get it to work right. Any help would be appreciated.

Thanks