calculate time

[SteveW]

Add.
In case result is more than 24 hours
Format cell as Custom [h]:mm

Steve

 

[Mr Frank Hellbusch]

Hi

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

Thanks
Frank

 

[Frank H]

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


Add.
In case result is more than 24 hours
Format cell as Custom [h]:mm

Steve

 

[David Biddulph]

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

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

Add.
In case result is more than 24 hours
Format cell as Custom [h]:mm

Steve

Hi

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

Thanks
Frank