Related:
- Excel formula converting time difference
- Excel formula convert number to words in rupees - How-To - Excel
- Excel formula convert text to date - How-To - Excel
- Excel repeat formula x times - How-To - Excel
- How to make formula in excel cell for time? ✓ - Forum - Excel
- Excel formula to find how many times a number appears ✓ - Forum - Excel
1 reply
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
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.
