Domino Code Fragment

Code Name*
Hours Between Two Times		Date*
04/29/2024		Source (or email address if you prefer)*
Rlatulippe@romac.com
IP address:.13.59.100.42
Description*
Determine the number of hours between two times.		Type*
Formula		Categories*
Date/Time Handling
Implementation:
Required Client:
Server:
Limitations:
Comments:
Files/Graphics attachments (if applicable): Code:
You will need to three fields for this calculation:

Field: StartTime
Type: Number, Editable
Time Format: 07:58
Formula Value: @Time(8 ; 0 ; 0) This displays a starting time of 8AM.

Field: EndTime
Type: Number, Editable
Time Format: 07:58
Forrmula Value: @Time(17 ; 0 ; 0) This displays a ending time of 5PM.

Field: NbrHours
Type: Number, Compute
Formula Value: @If(StartTime != "" & EndTime != "" ;
(EndTime - StartTime) / 3600 ;
Diff)