1

Topic: Question after time display

How to present type time "1/5/1900 of 0:17:00 AM" to a format "120:17:00"
Thanks

2

Re: Question after time display

It is possible so:

? format (hour (cdate ("1/5/1900 OF 0:17:00 AM")) +clng (cdate ("1/5/1900 OF 0:17:00 AM")-1) *24) AND format (cdate ("1/5/1900 OF 0:17:00 AM"), ":nn:ss")
120:17:00

Only be convinced that 120 hours at 5 numbers instead of 96 are necessary.

3

Re: Question after time display

Thanks