Hi. I have a spread that calculates the hours an employes has worked based on a Start and Finsh time. The Format of the time is 00:00. The claculation is just Finish time - start time. This works fine unless and employes finsihs on or after 00:00.

Does anyone know of calculation around this?

Also the times are netered via a vab user form. The times are selected from combox's that getting the dropdown values from a cell reference on the spread sheet.

When you selct 00:00 it is displayed as 00:05 and when you type in the time for some but not all times it gets displayed as a decimal.

Does anyone know to format the combo box so that this doesn't happen?

code for my combobox reads:

Private Sub FriStart1_Change()

FriStart1.Value = Format(FriStart1.Value, "hh:mm")


End Sub
Many thanks

Nods