Hello,

I am trying to create a worksheet that will calculate how much money one has
earned according to the total number of hours worked. I have tried
formatting my "Time" column using the following format options:

Category Type

Time 13:30:55

Time 37:30:55

Custom h:mm:ss

Custom [h]:mm:ss

Custom h:mm:ss;@

Custom [h]:mm:ss;@

But, I am having problems obtaining the formatting I want. First, my times
are all reading as "actual times", such as "05:59:59" reads as "5:59:59 AM",
or"23:59:59" reads as "11:59:59 PM" instead of just "23:59:59".

And second, once I go over 23:59:59, in my "time" column, such as
"24:00:03", it reverts back to "12:00:03 AM".

Does anyone know how I can format my "time" column so that it will not:

1.) Revert back if I exceed 23:59:59?

And

2.) So that my "times" column will not read as an "actual time", but rather as
the "time value" in actually enter, such as "42:55:23"?

I would greatly appreciate any assistance, information, or suggestions
anyone may have and I thank you for taking the time to read my question.

I hope you are having a nice day.


Sincerely,

IJ Johnson

Freelance Bookkeeper | Independent Contractor
www.ij-ic.freewebsitehosting.com