Microsoft Office Forums

Go Back   Microsoft Office Forums > >

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

I am currently using Excel 2007

In Cell A1 I have a start date of 14/6/13 09:01
In cell B1 I have an end date of 19/6/13 14:37
I have the following formula to calculate Hours and minutes
=INT(B1-A1)&TEXT(B1-A1,":hh:mm")

In Cell C1 i have another start date of 19/6/13 15:00
In cell D1 I have another end date of 20/6/13 17:32
I have another formula as above to calculate the hours and minutes

Is there an easier formula?

I would like to add the two calculated dates so I have one total.
I would also like it to calculate days, hours and minutes based on working days of Monday to Friday 9am to 5pm.
Reply With Quote
 

Tags
date, formulae, time



Similar Threads
Thread Thread Starter Forum Replies Last Post
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 10:24 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