Count time to time

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

Guest

How do I get the varience/hours between say 10:00 AM to 3:00 PM = 5 hrs.?
 
10:00 AM in A1
3:00 PM in A2
=A2-A1, formatted as [h]:mm would show 5:00
If you want 5 as a number for further processing, then use =(A2-A1)*24 and
format as number or general.
 
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

Subtracting time...again 2
Calculate elapsed time excluding specific timeframe 10
Calculate hours, past midnight etc 4
Excel Facetime Measurement 1
Extracting just the time portion 5
Macro / function text time to 24hr excel time passed midnight fortotaling hr's 2
separating date and time 5
using a time format in a count function 1

Back
Top