Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating time between two dates
In A1 enter 39101.6666666667
In B1 enter 39104.4583333333 In C1 enter =B1-A1 and you should see 2.7916666667 format A1 thru C1 as custom: m/d/yyyy h:mm:ss m/d/yyyy h:mm:ss [h]:mm and see: 1/19/2007 16:00:00 1/22/2007 11:00:00 67:00 -- Gary''s Student gsnu200701 "Sujith" wrote: Hi, I am making a report in which I want the time differance between two dates. Eg: In A1 the value is 19/01/2007 16:00:00 In B1 the value is 22/01/2007 11:00:00 A1 is responded time for an issue and B1 is resolved time. I want the result in C1 as the time differance i.e. B1-A1. When I refered the posts here, the formula =B1-A1 works only with MMDDYY format and does not work with my time format which is DDMMYY. I also want a formula to make excemption of holidays and off hours, say 20th and 21st Jan are holidays and working hours are from 9:00 to 18:00. Thanks, Sujith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating time | Excel Worksheet Functions | |||
Calculating Business Hours Between 2 Dates | Excel Discussion (Misc queries) | |||
Calculating Time Past Midnight | Excel Worksheet Functions | |||
How to create command button to save the dates and time | Excel Discussion (Misc queries) | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) |