how to find out hours worked between midnight and 6 am

		Microsoft Office Forums > Microsoft Excel > Excel
how to find out hours worked between midnight and 6 am

10-15-2016, 12:29 AM

xor

Windows 10 how to find out hours worked between midnight and 6 am

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,103

In D2:

=IF((A2<C2)*(A2>0.25),0,(0.25-A2*(C2>A2)-B2)*24)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
Calculate time from midnight on (Weekend hours, Fri-Sat night shift problem)	stormrider2230	Excel	1	01-20-2016 01:41 PM
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 01:39 PM.