jessika2105
New Member
- Joined
- Oct 4, 2022
- Messages
- 1
- Office Version
- 2003 or older
- Platform
- Mobile
Hi. I have checked on Internet. If I enter 8:00 pm in start time (cell A2)and enter 8:00 am in End time. (Cell B2). To calculate the difference, I have inserted the formula = (b2-a2)*24 I have then converted the formating to General to have the number of hours. However why I am getting -12
Second question from 8:00 pm to 8:00 am, I should get 11 hours, but I'm getting -13
Kindly help me
Second question from 8:00 pm to 8:00 am, I should get 11 hours, but I'm getting -13
Kindly help me