Previous Topic Next Topic

Time calculation

Solved/Closed
Osama_bb11
Posts
22
Registration date
Sunday May 25, 2014
Status
Member
Last seen
September 25, 2014
 - Sep 3, 2014 at 04:00 AM
Osama_bb11
Posts
22
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 )

Deeply thanks in advance

2 replies

Answer 1 / 2
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
 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
0
Answer 2 / 2
Osama_bb11
Posts
22
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
0