Hi all - I'm trying to create a very simple time sheet with 5 columns; name, time in, break (in minutes), time out, total minutes worked.

Times need to be entered in a military format (2130 for example) and while I have no trouble creating a simple formula such as "(end time - start time) - break" the whole thing goes capoot when the time worked goes over midnight, such as 2100-0300.

I've had a dig around but it seems to be a quagmire when it comes to working with time. Does anyone have any ideas?

Also - I don't specifically need it to be accurate to time - as long as a figure that proportionately represents how much time someone has worked is generated that will work just as well.

Thankyou!