Related:
- Excel formula converting time difference
- Excel formula convert number to words - How-To - Excel
- Excel formula to convert number to words in rupees ✓ - Forum - Excel
- How to make formula in excel cell for time? ✓ - Forum - Excel
- Excel formula to convert number to words in indian rupees ✓ - Forum - Office Software
- Excel formula how many times a number appears ✓ - Forum - Office Software
1 reply
venkat1926
- Posts
- 1862
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- July 30, 2015
first at least in my region the time is entered like this
10:49
12:12
etc a colon between the minutes and seconds.
suppose the first time is in A1
and second in B1
in any cell e.g. C1 type this formula
=B1-A1
format C1 as time without AM or PM
in C1 you will get 1:23 (not 1.63) means one minutes 23 seconds.
10:49
12:12
etc a colon between the minutes and seconds.
suppose the first time is in A1
and second in B1
in any cell e.g. C1 type this formula
=B1-A1
format C1 as time without AM or PM
in C1 you will get 1:23 (not 1.63) means one minutes 23 seconds.
Subscribe To Our Newsletter!
