How to set the table cells as time format?

[jiaron_1230]

in the column "from" and "to", is let the user to key in their working time, format as 24hr
after that, in std, n/std, n/std2, each of it hv different time area

std= 0800 - 1700
n/std=1701-2400
n/std2=2401-0759



i would like to do is calculate the hours that user had work.
Example,
from to std n/std n/std2
0900 0200 8 7 2

Can anyone help me with this?

[gmayor]

It's not that simple but the attached should give you a start point, though I haven't tested it thoroughly. The hours in the various segments are rounded up to the next hour. Then macro will run when you open the document. Personally I would save the document as a template, change the AutoOpen macro to AutoNew and create new documents from it as required.

[jiaron_1230]

Originally Posted by gmayor

It's not that simple but the attached should give you a start point, though I haven't tested it thoroughly. The hours in the various segments are rounded up to the next hour. Then macro will run when you open the document. Personally I would save the document as a template, change the AutoOpen macro to AutoNew and create new documents from it as required.

i opened your document, but that's not what i look for.
there is 31 days in that table,user will key in the wokring hours at day 3 but not day 1 and 2.
Is that got a way to do, like the user select the day 3, and key in the time, after that when the user hv work at day 6 or the other day, the user just select that day and thn key in the time, the hours will auto display?

[gmayor]

You would need to add a combobox to the userform to select between 1 and 31 then instead of using the loop to enter the values, use the number (with two added) to give you the row to fill. Thus you can fill any row.

I have modified the document to do that. I have annotated the code so you can see how it works and make your own modifications.