Expand my Community achievements bar.

Update how fusion handles user's date/time input

Avatar

Community Advisor

4/29/25

Description - 

I noticed that when users enter start time in Workfront (where the UI allows to specify time with up to a minute's accuracy), Fusion also adds seconds and milliseconds, which later leads to small discrepancies in processing.
For example, when the user inputs the start time as 15:00 and the end time as 16:00, Fusion doesn't show 1h as would be expected after calculating the time difference but rather 0.9904197222222223h.
I believe this is because 15:00 might be stored in the database as 15:00:01.500. Seconds and milliseconds can lead to subsequent inaccuracies in processing. 

Why is this feature important to you? Fusion gives inaccurate results when calculating time differences.

How would you like the feature to work - fusion always zero out everything smaller than a minute, because UI doesn't allow for specifying anything smaller than a minute.

Current Behaviour - Fusion silently and automatically modifies the time values as entered by users using the native Workfront .interface