I am making a time tracking wks and when a combo box is changed i want to put the DATE mm/dd/yy in colb the time hh:mm in colm c. when the next combobox change i want to put the time hh:mm in colm d and in col e compare the times so if i start at 09:00 and end at 10:15 col e will have 1.15 (hrs.Mins)

how do i format the date to be date only and the times to be in the time format i would like and then calc colm e?

Thank you