Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 06-25-2013, 04:25 PM
BobBridges's Avatar
BobBridges BobBridges is offline Formula to calculate Date and Time Windows 7 64bit Formula to calculate Date and Time Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Funckyfido, if Lonercom's answer satisfies you then feel free to ignore this (and mark the thread "solved"). But if all you want is display, I think you can indeed calculate the difference between your start and end date; just do the subtraction:

=B1-A1

Then change the format of the result to "[h]:mm". The brackets around the 'h' cause it to display all the hours involved, not topping out at 24. And after that, of course, adding them up is just as simple as a SUM function.

As for skipping weekends, I'm not sure what Lonercom is reading but if no work takes place on the weekends then the start and end timestamps will reflect that; no need to do anything special. But maybe I misunderstood that part of the question.
Reply With Quote
 

Tags
date, formulae, time



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 08:03 PM.


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