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
Osama_bb11 Posts 22 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 - Movies, series and TV
- We can’t review this decision because too much time has passed since your account was disabled. ✓ - Facebook Forum
- Whatsapp time setting - Guide
- Free electrical load calculation software - Download - Calculators
- Calculation is incomplete. recalculate before saving - Guide
2 replies
Mazzaropi
Posts
1983
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
February 27, 2023
146
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
22
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
