![]() |
#1
|
|||
|
|||
![]()
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. |
Tags |
date, formulae, time |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need a formula to calculate turnaround time | Rockitman31 | Excel | 9 | 09-07-2015 09:41 AM |
![]() |
prasad@dmci.ca | Excel | 1 | 11-29-2011 01:05 PM |
![]() |
Snvlsfoal | Word Tables | 1 | 08-11-2011 05:42 AM |
![]() |
grs | Excel | 3 | 02-21-2011 02:17 AM |
![]() |
jrasche2003@yahoo.com | Excel | 2 | 02-09-2007 07:10 AM |