elapsed time

  • Thread starter Thread starter ash
  • Start date Start date
A

ash

i have 2 different static times and i want to calculate
the elapsed time between them but i only want to work out
the hrs and mins not the secs is there a way 2 do this?
 
This will round to the nearest minute

=ROUND((B2-A2)/(1/1440),0)*1/1440

if you want to take off all seconds before the subtraction use

=FLOOR(B2,"0:1")-FLOOR(A2,"0:1")

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
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

screen updating problem 0
Access Access - Elapsed Time between Records 5
Elapsed Time returned from query 1
Calculate elapsed time excluding specific timeframe 10
elapsed dates between start and end date and time 2
How do I get time elapsed in terms of minute? 9
Elapse date and time 2
Time lapse to display in minutes 2

Back
Top