You are viewing limited content. For full access, please sign in.

Question

Question

OpenFormula - Calculate Difference Between Two times (HH:MM)

Forms Version 10
Updated November 30, 2016
asked on November 30, 2016 • Show version history

Is it possible to calculate between two different times in Laserfiche Forms?

I have two text fields where the user is entering their start time for the day (00:00 - 24:00) and End time for the day (00:00 - 24:00).

I know in excel I can use the TEXT() function, but it is not supported right now in Forms.

 

0 0

Replies

replied on November 30, 2016 • Show version history

I was able to calculate the difference between the times in decimal form, but am attempting to format the time now. 

Here is what I did.

Milliseconds

=((VALUE(INDEX(variable.End,ROW()))*5184000)/60/60/60)-((VALUE(INDEX(variable.Start,ROW()))*5184000)/60/60/60)

Seconds

=((VALUE(INDEX(variable.End,ROW()))*86400)/60/60)-((VALUE(INDEX(variable.Start,ROW()))*86400)/60/60)

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...