C
Cheryl
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!
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!