![]() |
|
|
|
#1
|
||||
|
||||
|
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. |
|
| 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 auto calculate Day of the week based on Date
|
prasad@dmci.ca | Excel | 1 | 11-29-2011 01:05 PM |
Calculate elapsed time in Word table?
|
Snvlsfoal | Word Tables | 1 | 08-11-2011 05:42 AM |
What formula should I use to calculate commission?
|
grs | Excel | 3 | 02-21-2011 02:17 AM |
How to get cells to calculate time?
|
jrasche2003@yahoo.com | Excel | 2 | 02-09-2007 07:10 AM |