I am Having issue with google Spreadsheet, how can I convert the 6.50min to 6.30 min-CodePudding

HOUR:MINUTE

It will show as 6:30, as shown in below screenshot:

or if you really want it to be displayed in decimal float format you can also manually do so in the Format tab > Number > Custom number format > In the box you can just type "h"."mm".

Refer to this link for more details on Date and Number Formats: https://developers.google.com/sheets/api/guides/formats

CodePudding user response：

Another alternative that can also be used

=TEXT(D10-C10,"h.mm")

I used the example image to create my own sheet and run some test based on the formatting nature of the Google Sheets. It gives me the exact 6.30 that you need, without the need of making too many changes on the formats.

You can review it over my testing Sheet

CodePudding user response：

I suggest you to not use h.mm if you want to have "numeric" hours. You will never be sure how many minutes you have.

On the contrary, when you see 6.10 you will be able to know that you have 6 hours and 6 minutes (1/10th of an hour), and when you see 6:30 you will be able to know that you have 10 minutes.