Shift_Clock

	Primary Column	Shift Start	Shift End	Total Hours	Start_Value	End_Value
	Collaboration powered by Smartsheet   |   Report Abuse
1	https://community.smartsheet.com/discussion/heres-fun-one#comment-5603
2	Determine hours from a drop down list of shift start / shift end times
3				Calculation
4		Drop down list	Drop down list	=IF(Start_Value4 >= End_Value4, "Error", (End_Value4 - Start_Value4) * 0.25)	=VALUE( RIGHT([Shift Start]4, 2))	=VALUE( RIGHT([Shift End]3, 2))
5	Good Data	4:00AM-00	4:15AM-01	0.25	0	1
6	Bad Data	5:00AM-04	4:15AM-01	Error	4	1
7	Bad Data	5:00AM-04	5:00AM-04	Error	4	4
8	Good Data	5:00AM-04	12:00AM-80	19	4	80