Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 06-24-2013, 04:42 AM
Lonercom Lonercom is offline Formula to calculate Date and Time Windows XP Formula to calculate Date and Time Office 2007
Novice
 
Join Date: Jun 2013
Posts: 6
Lonercom is on a distinguished road
Default

I had to convert the date/time to US from euro to get this to work using the date/time in the corresponding cells.

In A2 I used =SUM(B1-A1)
In A3 I used =SUM(D1-C1)
In A4 I used =SUM(A2,A3)

A2-A4 I formatted cells custom HH:MM:SS

A1: 05:05:36
B1: 01:02:32
C1: 06:08:08

Sorry, didn't see that you wanted to exclude weekends. Found this in another thread that mau point you in the right direction:

=IF(COUNTIF(HOLIDAYS!$C$4:$C$14,A5),"h",IF(OR(F5=" Sat",F5="Sun")," ",SUMPRODUCT(--(WEEKDAY(A5+1-ROW(INDIRECT("1:"&DAY(A5))),2)<6),--ISNA(MATCH(A5+1-ROW(INDIRECT("1:"&DAY(A5))),HOLIDAYS!$C$4:HOLIDAYS !$C$14,0))))
Hope this helps, If it's acting odd, try switching to US Dates
Reply With Quote
 

Tags
date, formulae, time

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to calculate Date and Time Need a formula to calculate turnaround time Rockitman31 Excel 9 09-07-2015 09:41 AM
Formula to calculate Date and Time Formula to auto calculate Day of the week based on Date prasad@dmci.ca Excel 1 11-29-2011 01:05 PM
Formula to calculate Date and Time Calculate elapsed time in Word table? Snvlsfoal Word Tables 1 08-11-2011 05:42 AM
Formula to calculate Date and Time What formula should I use to calculate commission? grs Excel 3 02-21-2011 02:17 AM
Formula to calculate Date and Time How to get cells to calculate time? jrasche2003@yahoo.com Excel 2 02-09-2007 07:10 AM

Other Forums: Access Forums

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


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