Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate time
Add.
In case result is more than 24 hours Format cell as Custom [h]:mm Steve On Mon, 16 Oct 2006 12:15:24 +0100, Mr Frank Hellbusch wrote: Hi I need a formula that will total the time using the 24 hour clock, e.g.. 06:30 17:00. Thanks Frank |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate time
Hi
I need a formula that will total the time using the 24 hour clock, e.g. 06:30 17:00. Thanks Frank |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate time
Hi
I am trying to total up hours over 10 days using this formula: =SUMIF(A3:BD3,"=Hours",A4:BD4) I'm getting a result of 1:36 when the correct result should be 75.5. I have tried both the 12 and 24 hour clock as well as custom h:mm. Still no joy. Frank "SteveW" wrote in message news:op.thihe3yaevjsnp@enigma03... Add. In case result is more than 24 hours Format cell as Custom [h]:mm Steve On Mon, 16 Oct 2006 12:15:24 +0100, Mr Frank Hellbusch wrote: Hi I need a formula that will total the time using the 24 hour clock, e.g. 06:30 17:00. Thanks Frank |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate time
Read the reply again. Not h:mm but [h]:mm if you want it in hours and
minutes. [... or multiply the answer by 24 and format as number if you want decimal hours.] However that doesn't explain the difference between 1:36 and 75.5, so I suggest that you look carefully at the numbers you are trying to add. If in doubt, set up a helper row with =A4 to =BD4 (or =24*A4 to =24*BD4) and format that as number and check those numbers against what you think you've got in row 4. -- David Biddulph "Frank H" wrote in message ... Hi I am trying to total up hours over 10 days using this formula: =SUMIF(A3:BD3,"=Hours",A4:BD4) I'm getting a result of 1:36 when the correct result should be 75.5. I have tried both the 12 and 24 hour clock as well as custom h:mm. Still no joy. Frank "SteveW" wrote in message news:op.thihe3yaevjsnp@enigma03... Add. In case result is more than 24 hours Format cell as Custom [h]:mm Steve On Mon, 16 Oct 2006 12:15:24 +0100, Mr Frank Hellbusch wrote: Hi I need a formula that will total the time using the 24 hour clock, e.g. 06:30 17:00. Thanks Frank |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time sheet drop down lists | Excel Discussion (Misc queries) | |||
Calculate the time an employee signed in and out plus rate per hr | Excel Discussion (Misc queries) | |||
HOW DO I CALCULATE TIME IN A TIME SHEET FOR EXCEL | New Users to Excel | |||
Calculate time | Excel Discussion (Misc queries) | |||
Calculate between two time formats | Excel Worksheet Functions |