Forum Discussion
Excel sheet time calculation on SharePoint
Hi, I have an excel file that shared on teams. I have a simple calculation formula e.g. =A2-B2 this cells contain 24h time list so I can calculate the working hours. the problem is with the eve...
Don't think it has anything to do with Sharepoint, Teams or even Excel.
The problem is the formula:
It doesn't really matter where you enter this
A1 B1 C1 = Formula B1-A1
| 16:00 | 01:00 | ########## |
It's also logical that it shows that way...because it calculates incorrectly.
it's all about 24 hours, .and since it's more than 24 hours here...
A1 B1 C1 = Formula =IF(B1<A1,((B1+1)-A1)*24,(B1-A1)*24)
| 16:00 | 01:00 | 9 |
After that it should display correctly everywhere 🙂
Hope I could help you with these information.
I know I don't know anything (Socrates)