Time calculation
Solved/Closed
Osama_bb11
Osama_bb11
- Posts
- 22
- Registration date
- Sunday May 25, 2014
- Status
- Member
- Last seen
- September 25, 2014
Osama_bb11
- Posts
- 22
- Registration date
- Sunday May 25, 2014
- Status
- Member
- Last seen
- September 25, 2014
Related:
- Time calculation
- Time calculations on a 24-hr clock ✓ - Forum - Excel
- Time calculation (TimeXnumber) ✓ - Forum - Excel
- Calculate Time Between 2 Dates in Excel - How-To - Excel
- Calculate each number is 1st time happen ✓ - Forum - Office Software
- One cell calculation Excel - Time Interval ✓ - Forum - Excel
2 replies
Mazzaropi
Sep 3, 2014 at 08:10 AM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
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
Sep 3, 2014 at 09:47 AM
- 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
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