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
Osama_bb11 Posts 21 Registration date Sunday May 25, 2014 Status Member Last seen September 25, 2014 - Sep 3, 2014 at 09:47 AM
Related:
- Time calculation
- Popcorn time download - Download - Movies, series and TV
- Calculation is incomplete. recalculate before saving - Guide
- Ocarina of time rom - Download - Action and adventure
- How to change time in whatsapp - Guide
- Facebook id verification time - Guide
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
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
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
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
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