# From Decimal To Hours And Minutes

Oct 20, 2007
I have a spreadsheet that keeps track of my flight time by the day and then totals it for the month however, I keep it in a decimal number (i.e. 89.23). I want the final total number to be in Hours and Minutes hhh:mm and can not for the life of me figure out the formula to make it come out in hours and minutes. I can either convert the one final decimal number over to hours and minutes or add the entire collumn of decimal numbers and have THAT total converted to hours and minutes. It's doesn't matter to me. I just can't figure out the formula.

View 9 Replies
ADVERTISEMENT
Jul 4, 2006

What formula will convert 4.50 to 530 minutes ( "Decimal Time" )

another example 16.50 to 1250 minutes.

View 13 Replies
View Related
Aug 29, 2007

How to I convert minutes into the equivalent fractional hours?

View 9 Replies
View Related
Nov 21, 2012

I am a truck driver and keep a record of my loading times when I am loading and unloading. At the end of a trip i transfer all the data to my computer, then "auto sum" the "HOURS" and the "MINUTES" columns. At the bottom of ech trip I end up with figures, lets say 32 (hours) in column "J" and 303 (minutes) in column "K".

Now 303 minutes is {5 hours and 3 minutes}. Now we all know that mathematically we can work out that {3} minutes is 0.05 of 1 hour and that would make the total time worked 32 (hours) + 5 (hours(from the minutes)) + the last 3 minutes and the total is 37 hours and 3 minutes.

What I am in need of is a formula that will take the hours in column "J" add the hours from column "K", leaving the minutes to be converted to 0.05, giving me a total in cell "M29" that can then be multiplied by the wage rate in cell "M30", giving me an amount that I should be paid in cell "M31"

View 6 Replies
View Related
Dec 2, 2006

I have two columns A and B. Column A contains problem title and column B is duration minutes. In column B we enter always min and seconds it took us to resolve certain issues (22.15 = 22 minutes and 15 seconds) . At the end of the month I need to run a report for my manager to show her by problem title how long it took my group to resolve issues and it should output as Hours/min/days.

View 5 Replies
View Related
May 25, 2011

I have a spread sheet with a colum showing average time to complete a task. This is currently shown as Days:Hours:Minutes:Seconds (4:19:33:19). I meed it to be shown purely as minutes, or at least as hours and minutes.

View 4 Replies
View Related
Dec 5, 2006

I have a formula which will calculate the number of hours and minutes between two military times. I would like it to calculate the total number of minutes instead of hours and minutes. I have uploaded a small example of what i have so far.

View 3 Replies
View Related
Jan 21, 2009

I'm trying to convert 3786 minutes to day:hours:minutes. So divided it by 1440 which is 2.63... but I want this displayed in the worksheet as 2 days 1 hour and 3 minutes (02:01:03), I just can't seem to get it to work and it seems quite simple... but I'm missing something.... I was trying a custom format like dd:hh:mm or [d]:hh:mm and I was also trying a convert function and =day/1440+hour +minute

View 9 Replies
View Related
Aug 22, 2006

creating a formula for converting time data that has been created in an excel spreadsheet in minutes i.e. 516 minutes which I need to turn into Hours and Minutes i.e. 08:36 I am not experienced using Formulas, apologies if this question has been posted before, I did use the search facility to look for threads, but could not find anything related

View 5 Replies
View Related
Jan 29, 2010

Format Time Cell For Greater Than 24 Hours: Hours & Minutes Only .....

View 9 Replies
View Related
Aug 30, 2007

1) The output of an excel duration is : 22.00:8.00:25.00 ( day:hour:minutes ) - excel cannot average and work with this number format

2) resolution - =(LEFT(L2,4))+MID(L2, FIND(":",L2)+1,4)/24+MID(L2, FIND(":",L2,7)+1,4)/1440 as an array and Custom Format the cell as [h]:mm - works perfectly.

Q: to be conistent, the initial reporting is dd:hh:mm and then I convert to hh:mm so that excel can process the data. How can I convert from hh:mm to dd:hh:mm so that the excel report can be consistent in presenting the data to senior management?

example attached.

View 9 Replies
View Related
Jul 4, 2007

I have a worksheet which I am trying to format as a template which includes inputting start times and end times of work and calculating how many minutes are taken to do the job. I just can seem to find the correct formula.

View 9 Replies
View Related
Oct 10, 2009

When I am converting a time from Hours/Minutes to Hours/Tenths, Excel is not converting it consitantely. EXAMPLE: 1:15 = 1.25. When I format the cell to present only one place past the decimal point, sometimes the cell will round up to 1.3, and other times it will round down to 1.2. What am I missing?

View 3 Replies
View Related
Oct 10, 2012

I am looking for a simple formula to change decimal minutes into seconds for example 0.12 = 7 seconds

View 3 Replies
View Related
Aug 11, 2006

I would like to convert a number to minutes. For example .48 or 48 as a formula result to 48 minutes. The reason for doing this is I will add the result to a time.

Forumula result = 48 -> convert to {48 minutes + 12:00 = 12:48}

I've tried using just formating but no luck.

View 9 Replies
View Related
Jun 12, 2013

I'm trying to convert degree minutes and second latitude and longitude to decimal lat and long in excel (I have 100s of such conversion to undertake). When trying out dividing the minutes and second by 60 and checking my calculation on Google Maps lat/long finder or Latlong.net my calculations are not correct. However the equation to other way around - converting from decimal lat long to DMS (*60) works.

View 2 Replies
View Related
Jul 27, 2009

I have an excel sheet with a row of numbers example below. These numbers represent the length of time that a telephone call was. The problem is they are decimal numbers (units of 100) but they represent seconds and minutes of a phone call which change up one number when the seconds hit 60 ...

View 9 Replies
View Related
Dec 20, 2009

i am trying to make a employee work hour sheet so i can add the time and it add up all the hours and minutes he/she been working . now what i am trying to do is to enter 810 in the cell it automatically change it to 8:10 format but the problem it change it to 12:00:00.

even when i enter 083612 it again change it to 12:00:00.

now i have used the format cell > time and no luck. i already removed and installed my office but i still have the same problem.

View 12 Replies
View Related
Mar 8, 2013

How to convert decimal numbers which represent minutes into time format? Like this

Sheet3 GH1MinutesTime212.9729729700:13:00325.9459459500:26:004116.756756801:57:00

View 2 Replies
View Related
May 6, 2008

I have listed a total amount of timings for a study that I have totalled giving me a figure of 34.76 which is under an hour.

how do i convert to min and seconds - is there a formula?

View 9 Replies
View Related
Sep 16, 2007

Need to convert decimal degrees into degrees, minutes, & seconds (displayed in three columns). Currently calculated manually from ATAN, ASIN, or ACOS functions.

View 4 Replies
View Related
Oct 17, 2008

I know similar questions have been asked in the past, but I can't seem to get this to work for my specific case. I need to convert hours into minutes, and these times do not conform to a 24 hour clock. For example, I need to convert 1000:15 into 1000.25

View 3 Replies
View Related
Jan 14, 2009

I have a database which shows a time some one came into work and a time they left. Formatted as HH:MM. I can minus the time they left from the time they came in...to work out how many hours they worked. However, whenever i want to work out how many mintes it is (time left - time in * 60). It does not seem to work.

Example

A1 - Time In 09:00

A2 - Time Out 17:00

A3 - Hours = 8 (A2-A1)

A4 - Mintes should be 480. (A3*60)

View 3 Replies
View Related
Sep 18, 2009

Unsurprisingly I have a spreadsheet:

Column D contains the total hours that a component has been installed for

Column C contains the additional hours the component acquired

I need the total of these 2 sets of time added together to give me the new hours that the component has acquired. All cells have been formatted [h]:mm:ss

I attach an extract of the spreadsheet. At the moment the values in column D are all calculated manually. When I add the values together Excel returns #Value!

The annoying thing is that in cells B2 and A3 I tested this and can do this with no problem...the value in B3 is the sum of B2 and A3.

View 2 Replies
View Related
Nov 3, 2009

I Need to add together different cells with hours and minutes. The attached workbook explains.

View 3 Replies
View Related
Aug 31, 2009

Cell D2 (Receiving) : 8/17/2009 17:19

Cell E2 (Dispatch) : 8/18/2009 10:33

I need to know the number of hours and minutes between the two (E2 - D2) in Hr:mm format.

View 4 Replies
View Related
Jun 10, 2013

I am trying to calculate employees hours of work from information provided to myself.

Each employee is contracted to work 40 hours per week. The information provided to myself is in the format - Employee has worked 39.30 This is in fact 39 hrs 30 minutes. Obviously when I subtract 39.30 from 40.00 I get 0.7 and not 30 minutes. I tried formatting the cell containing these figures to hh:mm but it comes out at 15.30 & 15.00 respectively because it is over 24 hrs. How do I convert the digital number (0.7) to minutes I.e. 30 minutes.

I have tried to convert the 40 hrs into minutes but because the hours are greater than 24 then I struggle.

View 9 Replies
View Related
May 12, 2009

=SUM(B10:G10)....answer is 245 minutes

How do I express this in hrs and minutes, 4hrs 5 mins.

Then I need to * this by an hourly rate to get a salary figure.

View 9 Replies
View Related
Jun 12, 2006

i don't know why this one stumps me but it does. I have a production schedule which shows how many hours and minutes are remaining for a given production run, i.e. 6.4 or 3.2. i want to do two things with these values. 1) add the 6.4 to the current time, something like a1 + now(0) to get the time the production run should end.

and

2) i want to add the number of minutes from a calculation to the current time, ie. 10:14 AM + 122 minutes = actual time the production ends. Nothing i do seems to give a desired result - including formatting the cell to any variation of the time format - including custom.

View 2 Replies
View Related
Feb 10, 2014

Cell A1 contains 2, B1=220077:23

In C1 I created a function = (2*1000)/B1, I get error. I want the answer 2000/220077h23m = 0.009087713

View 5 Replies
View Related