Time Range Total

HCL Domino Domino Forum
1

I only have one Date/Time field.Multiple value, display hours only so I get the hour range icon.

How do caculate hour diffence when hours are in a range in one field.

Frank

2

Subject: Time Range Total

dur := “06:13:32 AM - 10:27:19 PM”;high := @Hour(@TextToTime(@Right(dur; " - ")));

low := @Hour(@TextToTime(@Left(dur; " - ")));

@Text(high - low)

result is 16 hours

if you’re getting your range from a field then wrap @Text around it like this:

dur := @Text(timerange);

high := @Hour(@TextToTime(@Right(dur; " - ")));

low := @Hour(@TextToTime(@Left(dur; " - ")));

@Text(high - low)