Time Difference in VBA Macro
I'm trying to write a VBA macro to take the difference between two times
input by the user, calculate the difference, and put that value in the cell.
The first input box prompts for the start time (i.e. 9:00AM) and the second
prompts for the end time (i.e. 5:30PM). I've searched through this newsgroup
and done Google searches, but something just isn't sinking in. I need the
value to come out as a decimal value. With the 9:00 - 5:30 example, the cell
should show 8.5, but I keep getting -0.15. No doubt I'm missing something
obvious!
Thanks,
John
|