How can I transform a time value into its 24-hour equivalent? (i.e. 5:00PM to 17:00)

HCL Domino Domino Forum
1

Subject: How can I transform a time value into its 24-hour equivalent? (i.e. 5:00PM to 17:00)

2

Subject: Re: How can I transform a time value into its 24-hour equivalent? (i.e. 5:00PM to 17:00)

Could you give us some context, i.e., what language are you trying to do this in Formula, lotusscript, java, javascript, RPG?

How do you get the original time - is it text, a NotesDataTime, etc.

Thanks,

cpw…

3

Subject: RE: Re: How can I transform a time value into its 24-hour equivalent? (i.e. 5:00PM to 17:00)

Hi Craig:

It is in a date/time field, computed when composed.

Thanks

Gérald

4

Subject: RE: Re: How can I transform a time value into its 24-hour equivalent? (i.e. 5:00PM to 17:00)

Assuming the field is called fDateTime, then this will give you a text string of the 24hour eq.:

@Text(@Hour(fDateTime)) + “:” +

@Text(@Minute(fDateTime))

If fDateTime is [05/25/2004 03:14 PM] then that will yield a string:

“15:14”

5

Subject: RE: Re: How can I transform a time value into its 24-hour equivalent? (i.e. 5:00PM to 17:00)

Thanks, Craig, for your speedy response!

Gérald