Formula for a Time

[dbielenda]

I have a database field, SAWP030A.TGLMA, which is represented in minutes (let's use 60 minutes for this example). I need to convert that to hours and minutes, so I have used the following formula:

ToText(({SAWP030A.TGLMA})\60, 0) + ':' +
ToText(({SAWP030A.TGLMA}) Mod 60, 0)

The report shows: 1:0 which is correct, but I would like for it to look like 01:00, any suggestions on how to pad this?

Thank you

 

[rosemaryl]

Dear Dbielenda:

ToText(({SAWP030A.TGLMA})\60, "00&quot + ':' +
ToText(({SAWP030A.TGLMA})Mod 60, "00&quot

Notice that the format string is enclosed in quotes.

Hope this helps,

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[dbielenda]

Thanks, that seemed to work just great !