Time Calculation

The Animal

Active Member
Joined
May 26, 2011
Messages
449
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
 

Some videos you may like

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
Joined
Jun 7, 2011
Messages
1,723
Office Version
  1. 2010
Platform
  1. Windows
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
Joined
May 26, 2011
Messages
449
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
 

The Animal

Active Member
Joined
May 26, 2011
Messages
449

ADVERTISEMENT

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

Well-known Member
Joined
Nov 16, 2016
Messages
696
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
 

Watch MrExcel Video

Forum statistics

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

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...
  • Auto-Create a monthly Sign in sheet for preschool students
    The image below is what each page looks like. Above is space for the "Child Name" "Month" "Class" School days are obviously Monday-Friday but...
  • VBA vlookup multiple results
    Hi folks, Hopefully someone out there can help. I have a list to vlookup which works (ish). the lookup only picks up the first instance of the...
  • Extract values for earliest/latest times
    I am trying to put together a formula to get the earliest start time, the latest end time from column A for each person in Column B-F without the...
Top