ExcelBanter - calculate time

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - calculate time (https://www.excelbanter.com/excel-worksheet-functions/114567-calculate-time.html)

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

Hi

I need a formula that will total the time using the 24 hour clock, e.g.
06:30 17:00.

Thanks
Frank

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

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