Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
141
Views
Topic starter
Hi Every one
if i deduct F5 - G5 it should be 7.24 in timing format but system showing 7.94 so possible any formula to solve this issue.
Posted : 05/03/2024 8:10 am
Hello,
The numbers in F and G columns are just decimal numbers, not treated as time. Replace the comma with a colon and you will get the time values and correct calculation. See attached file.
Br,
Anders
Posted : 06/03/2024 1:51 am
