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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count occurences of time 1
How to do a formula counting the number of hours between 2 times? 2
Excel Catagorise AM or PM 7
Difference between date & time calculation 6
How to count the time slot? 4
How to count the time? 1
Calculating diff between date/ time only between certain hours 5
Calculating diff between date/ time only between certain hours 4

Back
Top