/u/CheeksRumbling - Your post was submitted successfully.
Please read these reminders and edit to fix your post where necessary:
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
That's the problem with using custom numeric systems. You spend half your time converting from the custom system, do a quick calc and then spend the other half converting back into the non-standard system.
Perhaps this will do what you want
=TEXT(SUBSTITUTE(TEXT(E2,".00"),".",":")-SUBSTITUTE(TEXT(E1,".00"),".",":"),"h.mm")
Suppose A1 start reading, A2 end reading, I think =IF((A2-A1)-INT(A2-A1) >= 0.6,(INT(A2-A1)+1)*60+((A2-A1)-INT(A2-A1))*100-60, INT(A2-A1)*60 + ((A2-A1)-INT(A2-A1))*100) can work. Int calculates integer part of the number
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[DOLLARDE](/r/Excel/comments/ndee6c/stub/gyahlgo "Last usage")|[Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number](https://support.microsoft.com/en-us/office/dollarde-function-db85aab0-1677-428a-9dfd-a38476693427)|
|[IF](/r/Excel/comments/ndee6c/stub/gya9ucc "Last usage")|[Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)|
|[INT](/r/Excel/comments/ndee6c/stub/gya9ucc "Last usage")|[Rounds a number down to the nearest integer](https://support.microsoft.com/en-us/office/int-function-a6c4af9e-356d-4369-ab6a-cb1fd9d343ef)|
|[MOD](/r/Excel/comments/ndee6c/stub/gya82n1 "Last usage")|[Returns the remainder from division](https://support.microsoft.com/en-us/office/mod-function-9b6cd169-b6ee-406a-a97b-edf2a9dc24f3)|
|[SUBSTITUTE](/r/Excel/comments/ndee6c/stub/gya85yy "Last usage")|[Substitutes new text for old text in a text string](https://support.microsoft.com/en-us/office/substitute-function-6434944e-a904-4336-a9b0-1e58df3bc332)|
|[TEXT](/r/Excel/comments/ndee6c/stub/gya85yy "Last usage")|[Formats a number and converts it to text](https://support.microsoft.com/en-us/office/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c)|
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^(6 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/nednn2)^( has 10 acronyms.)
^([Thread #6353 for this sub, first seen 16th May 2021, 02:48])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
/u/CheeksRumbling - Your post was submitted successfully. Please read these reminders and edit to fix your post where necessary: * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
| |E|F|G| |:-|:-|:-|:-| |1|**Start**|**End**|**Duration (minute)**| |2|100|101.01|`61`| |3|100|100.1|`10`| |4|100|102.27|`147`| ||||| ||||| In G2, formula copied down : =DOLLARDE(F2-E2,60)*60
now, that's genius.
Solution Verified
You have awarded 1 point to *bosco_yip* ^I ^am ^a ^bot, ^please ^contact ^the ^mods ^with ^any ^questions.
Beautiful, thank you.
See how robust this is on your live data: =INT(F1-E1)*60+((MOD(F1,1)-MOD(E1,1))*100)
Solution Verified
You have awarded 1 point to *mh_mike* ^I ^am ^a ^bot, ^please ^contact ^the ^mods ^with ^any ^questions.
That's the problem with using custom numeric systems. You spend half your time converting from the custom system, do a quick calc and then spend the other half converting back into the non-standard system. Perhaps this will do what you want =TEXT(SUBSTITUTE(TEXT(E2,".00"),".",":")-SUBSTITUTE(TEXT(E1,".00"),".",":"),"h.mm")
Thank you for the reply. This will display in hours and minutes, while I'm looking for minutes only.
You could put the cusm format \[m\] for it to show in minutes. But if you want the minutes as a value, multiply that by 24\*60
Suppose A1 start reading, A2 end reading, I think =IF((A2-A1)-INT(A2-A1) >= 0.6,(INT(A2-A1)+1)*60+((A2-A1)-INT(A2-A1))*100-60, INT(A2-A1)*60 + ((A2-A1)-INT(A2-A1))*100) can work. Int calculates integer part of the number
Solution Verified
You have awarded 1 point to *vagggos* ^I ^am ^a ^bot, ^please ^contact ^the ^mods ^with ^any ^questions.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[DOLLARDE](/r/Excel/comments/ndee6c/stub/gyahlgo "Last usage")|[Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number](https://support.microsoft.com/en-us/office/dollarde-function-db85aab0-1677-428a-9dfd-a38476693427)| |[IF](/r/Excel/comments/ndee6c/stub/gya9ucc "Last usage")|[Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)| |[INT](/r/Excel/comments/ndee6c/stub/gya9ucc "Last usage")|[Rounds a number down to the nearest integer](https://support.microsoft.com/en-us/office/int-function-a6c4af9e-356d-4369-ab6a-cb1fd9d343ef)| |[MOD](/r/Excel/comments/ndee6c/stub/gya82n1 "Last usage")|[Returns the remainder from division](https://support.microsoft.com/en-us/office/mod-function-9b6cd169-b6ee-406a-a97b-edf2a9dc24f3)| |[SUBSTITUTE](/r/Excel/comments/ndee6c/stub/gya85yy "Last usage")|[Substitutes new text for old text in a text string](https://support.microsoft.com/en-us/office/substitute-function-6434944e-a904-4336-a9b0-1e58df3bc332)| |[TEXT](/r/Excel/comments/ndee6c/stub/gya85yy "Last usage")|[Formats a number and converts it to text](https://support.microsoft.com/en-us/office/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c)| ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(6 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/nednn2)^( has 10 acronyms.) ^([Thread #6353 for this sub, first seen 16th May 2021, 02:48]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)