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.
--
Selma

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

On Jan 15, 1:22*am, Pastor Selma
wrote:
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.
--
Selma

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

On Jan 15, 10:22*am, Pastor Selma
wrote:
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.
--
Selma

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

"carlo" wrote in message
...
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

On Jan 15, 10:22 am, Pastor Selma
wrote:
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.
--
Selma

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

On Jan 15, 5:43*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Carlo forgot to tell you that in that case you'll also want to remove the
multiplication by 24.
--
David Biddulph

"carlo" wrote in message

...
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

On Jan 15, 10:22 am, Pastor Selma



wrote:
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.
--
Selma- Hide quoted text -

- Show quoted text -