Program with Hours

08-20-2017, 06:27 AM

NoSparks

Windows 7 64bit Program with Hours

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

In D1 this should also look after time that crosses midnight.

=IF(OR(A1="",B1=""),0,IF(OR(C1="x",E1="x"),(((B1-A1)+(B1<A1))*24)-0.5,((B1-A1)+(B1<A1))*24))

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Project Hours	Mav	Project	4	03-07-2014 04:47 PM
How to add hours together	PomDave	Excel	3	09-05-2011 04:43 AM
Not sure what program to use	komobu	Office	1	02-25-2011 04:14 PM
Help on the formulate hours	meninio	Excel	2	02-11-2011 04:56 AM
Don't know which program to use!	Raner	Office	3	12-09-2009 08:08 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:37 AM.