Easy Formula for Calculating Hours in Excel and Google Sheets

[@RameshKumar-pf6dl]

Excellent. This resolved my issue

[@JyotiKumari-y6t]

How to incorporate 4pm shift start time and 1 am shift end time in the formula. I have same case
Request received - 6/13/2024 2:07 am, request completed - 6/24/2024 8:04 pm

[@DataDashPro]

Simply input the end and start time and it will calculate the business hour.