Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

How to Calculate OverTime,Full_Day,Half_Day,Late_In,Hours,

Home
Forums
SQL

How to Calculate OverTime,Full_Day,Half_Day,Late_In,Hours,

Akhter HUssain

Akhter HUssain

7yAsked Dec 25, 2018, 11:45 PM1.6kSQL

i have INTIME and OUTTIME of employee ,

INPUT

EmpID	IN TIME	OUTTIME
2000092	2018-05-24 09:20	2018-05-24 21:00
2000090	2018-05-21 08:00	2018-05-21 20:00

OutPut

Hours(A)	Starndard Hour(B)	(C) Over Time(A-B)	OT Rate(D)	OT Amount(C*D)
11	8	3	100	300
12	8	4	100	400

i want this output in same table by sql query...Kindly guide

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Kalyani Shevale7y ago
refer this link
https://www.sitepoint.com/forums/showthread.php?644910-How-to-calculate-the-total-working-hours-of-an-employee-from-a-set-or-records
https://stackoverflow.com/questions/35907459/how-to-get-the-total-working-hours-for-employees-with-sql-server
https://www.sqlteam.com/articles/working-with-time-spans-and-durations-in-sql-server
https://dba.stackexchange.com/questions/14661/do-you-know-an-easy-way-to-generate-one-record-for-each-hour-of-the-past-12-hour