I have a dataset which shows the number of hours a lift has been out for. The client wants to see this in number of hours and minutes. They could be over 24 hours but they would still like to see it formatted as hours and minutes. I am unable to find a way to format the data where I can show number of hours over 24. Is this possible?
Hi @sorchas,
do you have a sample how you data look like and your customer want so see them?
BR
1 Like
Hi,
It looks like this in the csv file. I am unable to load in aws as there are invalid values (as you can see 673:55 hours, 31:40 hours etc). These have been out for longer than 24 hours. My client would like them to remain in this format.
Thanks!
And you want to do what exactly?
I want to be able to format this data is AWS in the HHH:mm format. In excel you can do this by adding brackets around [H]:mm which allows you to show hours over 24. In AWS you can only format hours up to 24 (from what I know of). I need to be able to perform calculations on these fields to show cumulative hours and changes over time but at the moment the only way to show this in the same format as the screenshot above is formatting as a string (which means I can’t perform calculations) or as a decimal (which means the cumulative hours aren’t correct). Do you know a way around this issue?
So actualy it is more a calculation issue rather then formating.
Because you want to e.g. sum 80:24 and 37:40?
1 Like
It’s a bit of both - formatting because AWS labels the field as having ‘invalid rows’ and therefore won’t import and calculation because if I convert to a decimal or integer I cannot correctly sum.
Ok. But at least you could use the field as a string value to import the rows correctly.
For calculation you have to build something, where you calculate the hours and minutes into integer (00:30 = 0,5 etc.). After that you could display it in HH:MM again.
e.g:
80:24 = 80,40
+37:40 = 37,66
=118:04 = 118,06
1 Like