How would I take the elapse time (not timer) and if the difference is less than 1 hour then display a message stated you have "xx" minutes left until 1 hour is up.
Ex:
Lets say the two times are 17:30-17:00=.5 hour
This is less than 1 hour so the message would state you have 30 minutes left.

Can this be done all within vba . If so how? Thanks.

Hi

You can use DateDiff function in VBA to find the difference between two date values (time included) and specify the same

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)