Hours Worked - AM and PM

		Microsoft Office Forums > Microsoft Excel > Excel
Hours Worked - AM and PM

FAQ

Thread Tools

Display Modes

11-18-2016, 02:48 PM

franco9999 franco9999 is offline

Windows 10 Hours Worked - AM and PM

Office 2016

Novice

Join Date: Nov 2016

Posts: 1

Hours Worked - AM and PM

Hello,

I have a spreadsheet of hours worked by employee labeled Time IN and Time OUT.

I need to be able to calculate how many hours were worked in the AM and how many in the PM.

My company determines the AM from 4AM to 4PM and the PM from 4PM to 4AM

I've tried using if statements and it got way to complicated. I'm wondering if anyone has a solution to my problem.

Thanks

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to find out hours worked between midnight and 6 am	acorn	Excel	2	10-15-2016 01:45 AM
Complicated calculation of hours worked	APreston	Excel	1	05-09-2016 04:42 AM
Very complicated calculation of total hours worked (PLEASE HELP)	APreston	Excel	1	05-08-2016 02:58 AM
Help with 'hours worked' calculation...	Snvlsfoal	Excel	1	08-11-2011 05:54 AM
Finding where I last worked on a document.	Balliol	Word	1	11-24-2010 04:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:45 AM.