Solved: Need to calculate end time in hours and minutes - Page 2

Griff · 12-15-2020 01:33 AM

I need to calculate what the time will be 7.6 hours after the start time, allowing for breaks taken. The following formula rounds my 7.6 hours to 8 hours. How do I get it to work out 7.6 hours or 7 hours 36 minutes after the start time?

0:07:36 +
MIN( SELECT( Timesheets[Start], AND([Worker]= [_THISROW].[Worker], [Work Date] = [_THISROW].[Work Date] ) ) )
+SUM( SELECT( Timesheets[Break], AND([Worker]= [_THISROW].[Worker], [Work Date] = [_THISROW].[Work Date] ) ) )

Suvrutt_Gurjar

Hi @Griff

Thank you , but I believe there was a typo in my suggestion. For adding 7 hours 36 minutes please try

“007:36:00” +
MIN( SELECT( Timesheets[Start], AND([Worker]= [_THISROW].[Worker], [Work Date] = [_THISROW].[Work Date] ) ) )
+SUM( SELECT( Timesheets[Break], AND([Worker]= [_THISROW].[Worker], [Work Date] = [_THISROW].[Work Date] ) ) )

With earlier suggestion “000:07:36”, I believe it adds 7 minutes 36 seconds.

View solution in original post