I have a formula to calculate the difference in time by seconds, i.e 108,000. When I try to convert to time using crtimefromsecssincemidnight(@total time), I get the error "out-of-range(0-86400). Is the a way to give me the total time 30:00:00 hours?
Thanks, Bill B
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.