Time sheet template military hours problem
Hi everyone,
I'm using the MS Excel online template numbered TC062071411033. In the cell
that calculates the hours worked from the time that the user inputs is a
formula as follows:
=IF((((D3-C3)+(F3-E3))*24)8,8,((D3-C3)+(F3-E3))*24)
This formula only works properly if the time entered is formatted in
military format. I want to use standard am/pm hours instead. Any idea of
how to change the formula so it will work correctly with am/pm?
Thanks!
|