By skyforbes I’ve been recently trying to use ChatGPT for creating spreadsheets and formulas for work. And it seems really cool what can be done and how quickly BUT much of the code/formulas never work, even when I’m as specific as possible about my aims and the software version I’m using (numbers, in the uk, Mac iOS). Plus it seems to send one around-the-houses: trying loads of different iterations of code that don’t work or are convoluted. Then eventually I either give up or it says “oh, there is actually a specific command that does that” …. Wtf why not just suggest that at the beginning??
For example: trying to create auto calcs of overtime based on start and end times. And then add rounding into the mix.
Hours of trying to use (duration) and (time) formulas. Struggling to convert time to a number and getting date/time errors. Then using pure maths to convert the time to an integer, and then round it. And suddenly it remembers there a dur2time (or something command) ??? wtf
Is this normal? Any tips would be greatly appreciated