Time calculation
Solved/Closed
Osama_bb11
Posts
21
Registration date
Sunday 25 May 2014
Status
Member
Last seen
25 September 2014
-
3 Sep 2014 à 04:00
Osama_bb11 Posts 21 Registration date Sunday 25 May 2014 Status Member Last seen 25 September 2014 - 3 Sep 2014 à 09:47
Osama_bb11 Posts 21 Registration date Sunday 25 May 2014 Status Member Last seen 25 September 2014 - 3 Sep 2014 à 09:47
Related:
- Time calculation
- Vat calculation excel - Guide
- Popcorn time download - Download - Movies, series and TV
- Calculation is incomplete. recalculate before saving - Guide
- Facebook id verification time - Guide
- Electrical calculation software free download - Download - Calculators
2 responses
Mazzaropi
Posts
1985
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
3 Sep 2014 à 08:10
3 Sep 2014 à 08:10
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
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 25 May 2014
Status
Member
Last seen
25 September 2014
3 Sep 2014 à 09:47
3 Sep 2014 à 09:47
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
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
