# Time calculation

Solved/Closed
Osama_bb11 Posts 21 Registration date Sunday May 25, 2014 Status Member Last seen September 25, 2014 - Sep 3, 2014 at 04:00 AM
Osama_bb11 Posts 21 Registration date Sunday May 25, 2014 Status Member Last seen September 25, 2014 - Sep 3, 2014 at 09:47 AM
Hello,

dear all

please I need a help for formula to calculate the duration ( hours ) between two dates

for example :

A1 ---> 1-8-2014 10:05 AM
A2 ---> 2-9-2014 09:15 PM

A3 ---> A2-A1 ( I need the result by hors )

Related:

## 2 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Sep 3, 2014 at 08:10 AM
Osama_bb11, Good morning.

A3 --> =A2-A1

Format A3 as Custom --> 37:30:55

Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Osama_bb11 Posts 21 Registration date Sunday May 25, 2014 Status Member Last seen September 25, 2014
Sep 3, 2014 at 09:47 AM
first at all thank you

maybe this will work also

=DATEDIF(B10,D10,"y")*365*24*60+DATEDIF(B10,D10,"ym")*30*24*60+DATEDIF(B10,D10,"md")*24*60+LEFT(TEXT(D10-B10,"hh-mm-ss"),2)*60+MID(TEXT(D10-B10,"hh-mm-ss"),4,2)

any way thanks a lot for reply