mySQL - Time in format 'HHH:MM:SS'

[kennymoens]

hi,

I've got a time in the 'HHH:MM:SS' format (can store more then 24h, up to 853 hours).

But I can't get the time_format function to work on it for values greater then 24h, anybody with a solution?

 

[spec]

Make the field NOT NULL and then when entering a either make the time NULL or leave it blank. It will automatically set the time.

I dont see why you want to go over 24h tho

 

[kennymoens]

The system is used for logging time of persons, this time cannot be said in days since they haven't done this for days, but they've done each time a few hours.

I know its a difficult way to tell it, but I don't now how to tell it clearly.

 

[spec]

If your logging online time I recommend you make a start time and an end time then in one collumn add the difference

 

[kennymoens]

I'll consider it