Forum Discussion
Struggling how to do a calculation
Hi, I am struggling on how to do a calculation, I have attached a spreadsheet below and would like to have a formula that takes the tick symbols of the contract type but only if there is no text in t...
Thank you this has helped perfectly, if possible could you help with my next problem i need to have the total hours gained and total hours lost actually be the hours and minutes instead of text
but i can't seem to know how to do it Savia
I don't follow what you mean - can you explain a bit more?
So as you can see on the spreadsheet I have a column for hours and a column for minutes and in the calculation I have hours gained and hours lost however right now it is in text form which means when i put 40 hours and 15 minutes it comes up as 40.25 gained, however i want it in the format of 50 hours 15 minutes in the same cell, hopefully this was easier Savia
- I understand now. Change the format to a custom number format of hh:mm.
I did that, however, it then says 06:00