subtracting time values to be able to track how long each task takes.
N Neil Jun 21, 2007 #2 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
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
F fredg Jun 21, 2007 #3 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])
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])
