Expression dissection

[omiaye]

Please I need some help to break down this expression. I can't find any help documentation on CurrentTime.

Timestamp(RangeSum(CurrentDate, Frac(Floor(CurrentTime*96)/96)))

Thanks.

[MayilVahanan · Accepted solution]

Hi

Try like below

=Timestamp(RangeSum(Today(), Frac(Floor(Now()*96)/96)))

[omiaye]

@MayilVahanan 
Please what is the significance of multiplication by 96?

[Chanty4u]

Hi 

It multiplies the current time by 96 (number of quarter-hours in a day) and then rounds down to the nearest integer.

[omiaye]

Thank you @Chanty4u. I am still trying to understand the importance of multiplication by 96. What value do you get by doing this multiplication or under what circumstance does one need to do this type of calculation? I would greatly appreciate any additional usage use cases. Thanks.