Excel 2003 Timesheet formula help

[NB1]

Hello,

I am trying to create a simple in/out setup for a timesheet and am stumped on this problem:

I need a formula that calculates hours past midnight for the same shift.

Right now I am using drop down lists for the ins and outs broken into 15 minute increments in military time. When I get to Midnight I get an error ex:

IN 8:00 OUT 17:00 = 9
but
IN 22:00 OUT 1:00(1:00am) = ######

I think I need an "if" statement that says, if the out time is less than the in time add 24 hours to the out time and subtract

Any suggestions?

Thanks

 

[Jonmo1]

Welcome to the board...

Try the MOD function..

=MOD(Out-In,1)


Hope that helps.

 

[NB1]

worked like a charm! thank you very much!