Count Hour differences between two specific times

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can you count the hours between times if the dates are not used? 1:30 PM compared to 9:30 AM the following day.

Thank You!
 
Hi ngrams:

=B1-A1+(B1<A1)

There is in fact a date there! It's 1-Jan-1900 it's just that you
don't see it without a date format. If you understand that, you'll see
why the above works. If B1<A1, it must be the next day, so add 1.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
ngrams said:
Can you count the hours between times if the dates are not used?
Click to expand...
1:30 PM compared to 9:30 AM the following day.
 
Back
Top