Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtract the time difference from another time difference | Excel Discussion (Misc queries) | |||
Comparing 2 files on date/time stamp, and based time difference do a subroutine | Excel Programming | |||
Daylight Saving Time (DST) and calculating time difference. | Excel Programming | |||
Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
Help with difference in time macro | Excel Programming |