# Time Calculation

#### The Animal

##### Active Member
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

### Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

#### yky

##### Well-known Member
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

##### Active Member
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

#### JumboCactuar

##### Well-known Member
P25
Code:
``=(G25/N25)/24``

format as [h]:mm

#### The Animal

##### Active Member

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

##### Well-known Member
dont know where 0.797 comes from but:

if F6 = 09:30 and I6 = 700

then
Items per Hour = 73.68
Code:
``=(I6/F6)/24``

Items per Minute = 1.22
Code:
``=(I6/F6)/1440``

#### The Animal

##### Active Member
Thanks so much works perfectly

Replies
7
Views
124
Replies
18
Views
304
Replies
6
Views
50
Replies
4
Views
86
Replies
5
Views
89

1,109,394
Messages
5,528,481
Members
409,819
Latest member

### This Week's Hot Topics

• Change military grades into rank
Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
• VBA COUNTIF SOLUTION
Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
• INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...