Calculating 2 Hour columns

Platform discussions
1

Hi all, I am trying to create a timesheet within monday.com. All of these hours are flexible and can include nightshifts.

Currently I have the following setup.

Start is an hours column
Finish is an hours colmn
Actual is a formula of - ROUND(TIMEVALUE("1/1/1 " & HOURS_DIFF({Finish},{Start}))*24,2)

Start Finish Actual
08:00 19:14 11.23

@JCorrell

The above works fine for day shifts. Night shifts the formula does not work.

Night shift would look like

Start Finish Actual
19:00 07:15 !!! - Want this to return 12.23

Can anyone help?

2

@jake.poole20

Give this a try:

IF(AND({Finish}, {Start}), 
  IF({Finish}>{Start},
    ROUND(TIMEVALUE("1/1/1 " & HOURS_DIFF(IF({Finish}>{Start},{Finish},""), IF({Finish}>{Start},{Start},""))) * 24, 2),
    ROUND(TIMEVALUE("1/1/1 " & HOURS_DIFF(IF({Finish}<={Start},"24:00",""), IF({Finish}<={Start},{Start},""))) * 24, 2) +
    ROUND(TIMEVALUE("1/1/1 " & HOURS_DIFF(IF({Finish}<={Start},{Finish},""), IF({Finish}<={Start},"0:00",""))) * 24, 2)
  )
,"")

Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday

2 Likes
3

THE MONDAY MAN DOES IT AGAIN!!! All working. Thanks Jim.

1 Like