Time Calculation

[The Animal]

Hi
In cell P25 I require an actual hours minutes value based on the value in G25/ the value in N25 rather than a number calculation.
I have changed P25 to hh.mm but confused as to the formula as G25 and N25 are numeric values ( in this case 258.5/133.3)

Thanks Stephen

 

[yky]

Excel uses store time and date as numbers. 0.5 is 12 hours, 1 is 24 hours. I don't know why your have 258.5. Is that 258 days and 12 hours?

 

[The Animal]

Thanks for your reply.
These number are different to above
I require P25 to give me a hh.mm value using numeric values G25 which is 3304 divided by N25 133.3 which equals 24.78 but I need the 24.78 to display as a time hh.mm rather than a number
Thanks for your help

 

[JumboCactuar]

P25

=(G25/N25)/24

format as [h]:mm

 

[The Animal]

Thanks for your reply.
Just a further question relating to above.
If I have a hh.mm value of 9:30 in F6 and a numeric value of 700 (which is the total items packed) in I6 I am trying to calculate a packing rate formula so if 9:30 is converted to minutes and then divided by 700 should give and answer of 0.797 but I am getting 0.03
And then I need a formula that gives me the items per minute based on above values of 700 items packed in 9:30 hh.mm
Any help would be great.
Thanks Stephen

 

[JumboCactuar]

dont know where 0.797 comes from but:

if F6 = 09:30 and I6 = 700

then
Items per Hour = 73.68

=(I6/F6)/24

Items per Minute = 1.22

=(I6/F6)/1440

 

[The Animal]

Thanks so much works perfectly