none
Time Formatting RRS feed

  • Question

  • I have two field of data, Starttime & endtime which result as date & time example 30/09/2009 00:01:30

    In my table I have an expresion endtime - starttime to get the difference between the two which formats example 1.18:30:00 (1 day 18hrs 30 mins 0 sec)

    Is it possible to get it to format as either of the following:

    1 D 18 H 30 mins     or

    1.18:30
    Friday, September 25, 2009 11:22 AM

Answers