how to calculate time diffrence

  • Thread starter Thread starter mangesh
  • Start date Start date
M

mangesh

hi
i have put time intime in cell A1 and outtime in cell B1 how to find
out the difference between these time? can you please help me for that
 
hi
i have put time intime in cell A1 and outtime in cell B1 how to find
out the difference between these time? can you please help me for that
Click to expand...


=B1-A1

format as [h]:mm for hours & minutes.


--ron
 
Hi
try
=B1-A1+(B1<A1)

the part (B1<A1) is required if your times span midnight
 
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

Continuous form "#Error" in new record 1
calculating the time between one date and another 1
Time Format and Calculate difference in time 2
Adding Time 2
Time Calculations 1
summing time 4
How to convert two dates in to HH:MM:SS 1
Time Difference Formula 3

Back
Top