Forum Discussion
Ella2314
Sep 07, 2022Copper Contributor
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...
NikolinoDE
Sep 08, 2022Platinum Contributor
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)