The spin buttons will require VBA, and will be a little more complex than I can go into here... but I will try to cover this in a future class on Excel VBA (you need to make a custom function and use date functions).
Converting to local time wouldn't be that hard if you know your UTC offset (like Eastern is -5). Just subtract that number of hours from the UTC time. For example, if A1 contains 17:00, and B1 contains -5 (your UTC offset) then put this in C1:
=A1+(1/24*B1)
Remember, an hour is 1/24th of a day. Format that cell as a TIME, and that should do it.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.
