help creating a time function
Hi
=A1-TIMEVALUE("8:00")
Format the resulting cell as time.
Regards,
Per
On 22 Jan., 02:29, 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!!!
|