Convert Number into Time

[DougB13]

Working on a report where the time an episode starts and ends is displayed as a number field which is actually military time. I need to have the report convert it to standard time.

begin time end time
2015 2215
1125 1211

 

[lbass]

stringvar begint := totext({table.begintime},"0000");
time(left(begint,2),right(begint,2),0)

Create a separate formula like this for end time. Place these on the report and then go to format date->time and change the format to standard time.

-LB

 

[DougB13]

I receive a message that too many arguments have been given for this function. Below is the formula I have.

stringvar begint := totext({visit.begin_time},"0000");
time(left(begint,2),right(begint,2),0)

 

[lbass]

Then I'm guessing that your field is already a string, not a number. In case the field is not always four characters, try:

stringvar begint := totext(val({visit.begin_time}),"0000");
time(left(begint,2),right(begint,2),0)

-LB

 

[DougB13]

I believe the first formula was almost there. right(begin,2),0) was highlighted when the too many arguments message appears. The second formula does not work at all.
Thank You for your response.

 

[kskid]

How about...

stringvar begint := totext({visit.begin_time},"0000");
time(val(left(begint,2)),val(right(begint,2)),0)

 

[DougB13]

That works just fine. Thank You. You wouldn't happen to know a formula to fine the difference in time?

 

[lbass]

Sorry, I forgot to convert it back to a number. Can we assume you are looking for the time difference within the same date? If so, you could use:

datediff("n",datetime(currentdate,{@starttime}),datetime(currentdate,{@endtime}))

This would give you the difference in minutes.

-LB

 

[DougB13]

Thank You for your help both lbass and kskid.