Macro Sum Time with error, returnme 13 hours always

[feroguz]

Hi!Good Morning!!

I have a problem with this workbook, in this section:

Please Login or Register  to view this content.

SUM a time, but always returnme 13hours, whats the problem with this function??

I need a help!!

Attach the file!

Best Regards!!

[Norie]

Format D4 as [h]:mm.

[feroguz]

Hi Sr,

the cell is formatted, but doesn't perform the operation correctly ..

Attach the screenshot format.jpg

[Norie]

When I run the code the cell does display 13:00 but when I then format the cell as [h].mm it displays 37.00 which is the correct value.

In your image the format is h.mm not [h].mm, the brackets around h are important.

CumTimeFormat.JPG

[feroguz]

ahh jajaja!! I understand the importance that the brackets!!

Dear Sr, thanks again!!