I will explain it step by step.
I set the date and time to work exactly as it is so that it can be reflected even if the date changes.
BC
2017/12/07 11:03 2017/12/08 0:54
If you do this, the text will also be in date format, so =C-B will be 13:51.
When I enter the date on the Android app, the format is initialized and I can't format it. So I decided to hide B and C if I only want to write the time, and D and E only show B and C.
BCDE
December 7, 2017 11:03 December 8, 2017 0:54 =RIGHT(B3,5) =RIGHT(C3,5)
As mentioned above, the app cannot format it, so there is a possibility that the number of digits will be 2:05 at 02:05 at 2:5 at the same time. Therefore, instead of using the RIGHT function, we decided to use the INT function to get the date.
D
1899/01/01 11:03
It turned out that
How do I format Google Sheets API on Android?
android google-spreadsheet
First, the Excel date and time is a real number of serial values (milliseconds from January 1, 1970).Not a string.
Because you use a string function (such as Right) for data that is not a string, the result is unexpected.
On Android, you can also get serial values using Java.lang.system.currentTimeMills().
I don't understand what it means to enter a date on the Android app and the format is initialized and cannot be formatted.
What kind of functions does the Android app have?
How are Excel running machines connected to Android machines?
And how does the Android app input data into Excel?
and so on.
And while Google SpreadSheet looks similar to Excel, there are many differences, such as one app on the web and the other on the PC.
We strongly recommend that you add details such as system configuration to the question.
It's hard to answer something you don't know.
© 2024 OneMinuteCode. All rights reserved.