Subtracting two time values

  • Thread starter Thread starter Guest
  • Start date Start date
Subtract one from the other using the date component as well as the time
component. Then multiply the resulting value (which will be in days) by 24
to get hours; 24 * 60 to get minutes; etc.

Neil
 
subtracting time values to be able to track how long each task takes.
Click to expand...

Look up the DateDiff function in VBA help for all of the arguments.

=DateDiff("s",[Time1],[Time2])
 
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 values in Access 1
Time Calculations..subtracting Minutes 3
Excel Having trouble subtracting one cell from another and storing the result. Pls help. 3
Subtracting time 1
how do I make a number entered in one table subtract from another 2
How do I subtract starting time from ending time 1
need help writing a formula!!! : ) Please I need to write a formulathat will subtract .5 (half an ho 2
Subtract Dates stored as text fields 9

Back
Top