ddrake
Technical User
- Mar 19, 2003
- 92
Hi all!
I've got a couple of date/time fields in my report that I subtract one from the other. What I get is in seconds. I then convert the seconds to hours and report that value. Of course, it is shown like 204.5 hours. However, we'd like to convert/format that data to show in HH:MM:SS like Excel shows it. Has anyone ever done something like this? Thanks!
Dave
ex. (1/1/2004 12:00:00 AM - 1/1/2003 12:00:00 AM) = 31536000 seconds or 525600 minutes or 8760 hours
Crystal 9.0, SQL 2K, Win2K Server
I've got a couple of date/time fields in my report that I subtract one from the other. What I get is in seconds. I then convert the seconds to hours and report that value. Of course, it is shown like 204.5 hours. However, we'd like to convert/format that data to show in HH:MM:SS like Excel shows it. Has anyone ever done something like this? Thanks!
Dave
ex. (1/1/2004 12:00:00 AM - 1/1/2003 12:00:00 AM) = 31536000 seconds or 525600 minutes or 8760 hours
Crystal 9.0, SQL 2K, Win2K Server