Calculate Time per Period: Type Mismatch

Hi guys,

I am trying to calculate and add up the total time for a specific date period.

But I get a Run-time error: 13 - Type Mismatch

On this line:

Please Login or Register  to view this content.

i have attached a sample workbook.

Thank you in advance for all your help!

Hi all,

i figured it out, but could still do with some help solving it:

Not Working: The format in my cell is 12:47. When you click on it, it also show 12:47 in the Formula Bar.
Working: The format in my cell is 12:47. When you click on it, it shows 12:47:00 PM in the Formula Bar.

How can i edit this code to work either way?

Thank you!

Hi joeu2004

Thanks for the feedback. I realize the format issues (like you explained). I was hoping to do the formatting via VBA, and not in the sheet. I want users to stay away from the sheet and the data. Safeguard it as much as possible.

This is the actual code I am using to format the time field to save it to the sheet in this format HH:MM

Please Login or Register  to view this content.

Perhaps any suggestions on how I can edit this to save in my desired format, but as numeric time?

Thank you!

Ah! Perfect, thank you!