help creating a time function
in [Functions]
|
Prev: Is there a function in excel where you can the beginning of the mo
Next: How do I change date that is in All Caps to proper format?
From: Josh on 21 Jan 2010 20:29 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!!!
From: Per Jessen on 21 Jan 2010 20:56 Hi =A1-TIMEVALUE("8:00") Format the resulting cell as time. Regards, Per On 22 Jan., 02:29, Josh <J...(a)discussions.microsoft.com> 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!!!
From: Teethless mama on 21 Jan 2010 21:26 =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!!!
From: Josh on 21 Jan 2010 21:38 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!!!
From: Josh on 21 Jan 2010 21:48
Per, That worked PERFECTLY!!! Thank you!!! Now one more question. I am also trying to add up the time but the simple =sum (a2:d2) doesnt work. Is there a special one for time? "Per Jessen" wrote: > Hi > > =A1-TIMEVALUE("8:00") > > Format the resulting cell as time. > > Regards, > Per > > > On 22 Jan., 02:29, Josh <J...(a)discussions.microsoft.com> 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!!! > > . > |