Hello. I have a timesheet I am attempting to convert to vba. In my total column I have this formula =((F4-C4+(F4 < C4))-(E4-D4+(E4 < D4)))*24. I am trying to convert it to a select statement. My attachment has an example.
By the way i noticed that if a user enters 12:00 am as a start time it will not show up in the cell but it does appear in the formula bar. I know that if the user enters 24:00 then I will see 12:00 am in the cell. Most of the users do not care for military time so I have to stick with the civilian time format. Any thoughts as to why this occurs.