Time Calculations Across Midnight

  • Thread starter Thread starter Sam Thurmond
  • Start date Start date
S

Sam Thurmond

How can I determine elapsed timed when the times cross
midnight? I have two columns of times that I need to use
to get the elapsed time. It iw easy enough as long as
the start and end don't pass midnight - if they do I
can't get the right times! Thanks in advance.
 
Try

=MOD(A2-A1,1)

works for times before midnight as well,
A2 hold the end time and A1 the start time
 
Back
Top