Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help creating a time function
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!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help creating a time function
=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!!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help creating a time function
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 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!!! . |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help creating a time function
Thanks for your reply.
Sure, =SUM(A2:D2) work on time, but if the result exceeds 24 hours, you have to format the resulting cell as Custom: [h]:mm to show the result as hours. (Goto Format Cells Number Custom Type: [h]:mm) Regards, Per On 22 Jan., 03:48, Josh wrote: 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 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!!! .- Skjul tekst i anførselstegn - - Vis tekst i anførselstegn - |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help creating a time function
Hello Per,
I have tried this method and it still comes up as 0:00. I even made the custom [h]:mm and used the h:mm format. Here is what the cell format is currently =SUM(J2:J34) It is formatted as [h]:mm "Per Jessen" wrote: Thanks for your reply. Sure, =SUM(A2:D2) work on time, but if the result exceeds 24 hours, you have to format the resulting cell as Custom: [h]:mm to show the result as hours. (Goto Format Cells Number Custom Type: [h]:mm) Regards, Per On 22 Jan., 03:48, Josh wrote: 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 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!!! .- Skjul tekst i anførselstegn - - Vis tekst i anførselstegn - . |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help creating a time function
I just noticed that if it is actual time it works. What I am trying to
caculate is the extra time with this formula. =TEXT(E30+I30,"h:mm") How can I add that time up? "Per Jessen" wrote: Thanks for your reply. Sure, =SUM(A2:D2) work on time, but if the result exceeds 24 hours, you have to format the resulting cell as Custom: [h]:mm to show the result as hours. (Goto Format Cells Number Custom Type: [h]:mm) Regards, Per On 22 Jan., 03:48, Josh wrote: 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 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!!! .- Skjul tekst i anførselstegn - - Vis tekst i anførselstegn - . |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help creating a time function
If you want to add it up, you need to make it a time, not text, so
=E30+I30 (and format as [h]:mm) -- David Biddulph Josh wrote: I just noticed that if it is actual time it works. What I am trying to caculate is the extra time with this formula. =TEXT(E30+I30,"h:mm") How can I add that time up? "Per Jessen" wrote: Thanks for your reply. Sure, =SUM(A2:D2) work on time, but if the result exceeds 24 hours, you have to format the resulting cell as Custom: [h]:mm to show the result as hours. (Goto Format Cells Number Custom Type: [h]:mm) Regards, Per On 22 Jan., 03:48, Josh wrote: 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 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!!! .- Skjul tekst i anførselstegn - - Vis tekst i anførselstegn - . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating many hyperlinks at a time | Excel Discussion (Misc queries) | |||
creating median of time period | Excel Discussion (Misc queries) | |||
creating a time formula | Excel Worksheet Functions | |||
Creating Time Sheet | Excel Discussion (Misc queries) | |||
Creating time chart | Charts and Charting in Excel |