help creating a time function
Thanks Teethless mama.
Now where would i put this? I tried to put it in a cell and link it to my
time, but the format just shows 12:00 AM
"Teethless mama" wrote:
=MAX(A1,"8:00")-"8:00"
"Josh" wrote:
Hello,
I am trying to create a time function that will look at a typical day and
add the hours. Then show how many hours after 8 is overtime. I have the
first part created, but how can I write a formula that will look at say 12:45
hours and tell me 4:45 of it is overtime? Please help!!
Thanks!!!
|