Dreamer
05-01-2008, 04:43 PM
Dear all,
Please advise how to take the time difference of 2 dates...
e.g starttime is 1:45:00, endtime is 3:00:00,
how to calculate the difference in VBA and do the rounding?
endtime-starttime = duration =01:15, but i want to let it become "2 "(integer/value is preferred)?
Thanks so much..
Please advise how to take the time difference of 2 dates...
e.g starttime is 1:45:00, endtime is 3:00:00,
how to calculate the difference in VBA and do the rounding?
endtime-starttime = duration =01:15, but i want to let it become "2 "(integer/value is preferred)?
Thanks so much..