Military time viewed as civilian time

[Ms. Thompson]

I have a time sheet template saved in Excel with all of the
appropriate formulas to calculate hours worked after subtracting
lunch, then adding each day taking into account overtime, etc. For
these formulas to work, I must use military time (at least I think
so). Now the girl at the office who inputs all payroll information
into our payroll company's database says that she does not want to see
military time on the time sheets. How can I still use the appropriate
format so that the formula will work and it still be viewed as
civilian time?......or is this even possible?

 

[Andy B]

Hi

What do you mean by military time? Do you mean 24 hour time (18:30) or 1830,
or something else? If it is an Excel time, then it's just a case of changing
the cell format. If the calculations rely on it being entered as 1830, you
are going to have to have either a worksheet event change macro, or some
hidden calculations to change whatever has been entered (18:30 or 6:30pm)
into what you want (1830)

 

[Don Guillett]

The time calculations do not care how the cell is formatted. Just change the
format.
An hour is 1/24 of a day, so to convert to fractions multiply by 24.