Question Locked
0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Hi, I am trying to add monthly working hours together eg 171.25 hours + 56.56 hours but cannot get Excel to do this. When I use HH:MM it changes the cell to a time format but the answer is wrong despite the correct (I think) sum is entered in the total colom ie SUM(B3:CC3). All cells have been set to HH:MM format but again when I enter the hours it changes the value. Can anyone help as I am going mad trying to fix this!?
2 replies
by angiewelly Accepted solution
Clarifications
by tg2 Accepted solution
Try this..
in excel 2003, I right clicked a row of cells, did "format cels", selected TIME in the category box, then for TYPE chose the one that shows me 37:30:55
with that selection, the time I see in the column is the amount I entered. If I physically click on one of the cells **after** I have entered a value, the top of the screen shows the time in hours/am/pm format, but the visual column shows me hours:mins:secs
This discussion is closed to new replies.
Trending Software posts
Sort by Trending
1 helpful
1 reply
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
0 helpful
5 replies
0 helpful
20 replies
Discussion
Is There any Reverse Video Search Tool
0 helpful
8 replies