Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Program with Hours
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 08-20-2017, 06:27 AM
NoSparks NoSparks is offline Program with Hours Windows 7 64bit Program with Hours Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
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))
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Program with Hours Project Hours Mav Project 4 03-07-2014 04:47 PM
Program with Hours How to add hours together PomDave Excel 3 09-05-2011 04:43 AM
Program with Hours 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
Program with Hours 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 12:35 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft