Calculating Time over 2 days

[Jane]

I have a timesheet that covers employees that work the
night shift. I am looking for a way for them just to
enter start time and end time and have the cell calculate
time worked. The way I have it they have to enter start
mm/dd/yy hh:mm am/pm. End time is the same, then the cell
calculates fine, but I sure would like them to just enter
hh:mm am/pm

 

[Andy Brown]

I sure would like them to just enter

hh:mm am/pm

For your calc, use

=MOD(B1-A1,1)

or

=B1-A1+(A1>B1)

A1 = start time, B1 = end time.

Rgds,
Andy

 

[Frank Kabel]

Hi Jane
one way if
A1: starting time
B1: end time
=B1-A1 +(B1<A1)*24

Frank

 

[Roger Govier]

Hi Jane

With start time in A1 and end time in B1 try
=A1-B1+1*(A1>B1)

 

[Frank Kabel]

Hi
sorry typo: try
=B1-A1 +(B1<A1)

Frank

Hi Jane
one way if
A1: starting time
B1: end time
=B1-A1 +(B1<A1)*24

Frank

 

[Guest]

Got It,thank you all very much! Your help is invaluable!