Calculating time

[Pastor Selma]

Hello out there!

I have a simple time calcution in Excel and for some reason when the time
contains minutes to does not calculate right. Here's an example.

Start Time End Time Total Hours
8:00 AM 4:20 PM 8.33

the calculation is =(E26-D26)*24

It should have come out to 8.20 but came out to 8.33. Can someone help!

Thanks.

 

[Pete_UK]

By multiplying the formula with 24 you are converting the result into
decimal hours, so 8.33 means 8 and 1/3 hours, or 8 hrs and 20 mins. If
you want it to be displayed as 8:20, then format the cell as time and
change the formula to:

=E26-D26

Hope this helps.

Pete

 

[carlo]

Well....the problem is, that 8.33 is the correct answer.

you need to format your end cell as time, otherwise it will end with
this result.
20 minutes is a third of an hour, your cell displays with hundreds and
a third of one hundred is .33

Right click on your cell, format cells, go to custom and enter [h]:mm

hth

Carlo

 

[David Biddulph]

Carlo forgot to tell you that in that case you'll also want to remove the
multiplication by 24.
--
David Biddulph

Well....the problem is, that 8.33 is the correct answer.

you need to format your end cell as time, otherwise it will end with
this result.
20 minutes is a third of an hour, your cell displays with hundreds and
a third of one hundred is .33

Right click on your cell, format cells, go to custom and enter [h]:mm

hth

Carlo

 

[carlo]

yepp

David is right.....actually didn't forget....just didn't look at your
formula.
Sorry about that.
Thanks for pointing it out David and Pete.

Cheers
Carlo

Carlo forgot to tell you that in that case you'll also want to remove the
multiplication by 24.
--
David Biddulph


Well....the problem is, that 8.33 is the correct answer.

you need to format your end cell as time, otherwise it will end with
this result.
20 minutes is a third of an hour, your cell displays with hundreds and
a third of one hundred is .33

Right click on your cell, format cells, go to custom and enter [h]:mm

hth

Carlo

Hello out there!

I have a simple time calcution in Excel and for some reason when the time
contains minutes to does not calculate right. Here's an example.

Start Time End Time Total Hours
8:00 AM 4:20 PM 8.33

the calculation is =(E26-D26)*24

It should have come out to 8.20 but came out to 8.33. Can someone help!

Thanks.

- Show quoted text -