How to display the total hours and actual hours of the employee as the time spent in office when there are work from home and work from office entry for same day?

1

SQL Fiddle

Also, reducing your problem down to a minimal reproducible example, along with some sample data (and ideally a http://sqlfiddle.com/ or https://dbfiddle.uk/ link) will get you much better answers.

#Online Learning #Online Education #Online Courses 59 social mentions

2

db<>fiddle

Also, reducing your problem down to a minimal reproducible example, along with some sample data (and ideally a http://sqlfiddle.com/ or https://dbfiddle.uk/ link) will get you much better answers.

#Online Learning #Online Education #Online Courses 19 social mentions