I was messing around with a simple countdown timer and need a little help converting a decimal into a format of #days, #hours, #minutes and #seconds.

Cell A1 has target to countdown to 4/14/2010 12:00:00 AM
Cell A2 contains =NOW()
Cell A3 contains =A1-A2 with the result being 69.4021441 with the amount of decimal places varying depending on when it is refreshed.

I'd Like the result in A3 to read something like "There are 69 days, XX hours, XX minutes and XX seconds until event"

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.

The below formulae allows me to see the difference between two dates and only returns the difference in working hours ie : Difference between 02/02/2010 08:00 & 03/02/2010 08:00 is 16 Hours 0 Minutes

=(INT(A3)-INT(C6))+MAX(MOD(A3,1)-MAX(MOD(C6,1)))

The following displays it in the Hrs and Mins format

I have an entire column with numbers such as 48, 95, 30 etc representing hours. how do i format cell so that these numbers will show, 2days, 3days-23hrs-45mins, 1day-6hrs

Thought it would be easy enough to just right click and format the cell but doesn't seem to have the option *shrugs*.

I have a column of tasks that take a certain amount of time to complete formated as h:mm:ss. I want to total the column and convert the total to days, hours and minutes. Is that posible and if so how do I configure a formula and format the cell? example:

I have a data feed that gives a column of cells formated mm/dd/yy hh:mm These are call entries, what i want to do is count all the occurances each hour, so count all the entries say between 9am and 10am. However the column is very long and holds data for many weeks so i want to be able to ignore the date part of the cell.

Formula that will change seconds to hours and mins, example 270 mins would show up as 4 hours 30 mins, not 4.5 hours. My second thing is how can I double the times in the same formula.

If a person does a full day I want the formula to calculate how many hours minus 30 mins for lunch i.e. 7:30 - 4:00 = 8 hours. I have done this and it works fine, the problem comes when a person does a half day i.e. 7:30 - 11:30, this will read 4.5 hours. If this is the case I don't want the 30mins deducted so it should be 4.0 hours worked.

I have high lighted a column in the work sheet (yellow) whereby the user puts an 'x' in the appropriate cell if they are working a half day.

The probem is I cannot incorperate the two formulas in one cell (the Actual hours cell) I have the one formula in the actual hours cell and the other bolted on the end thus giving two different readings.

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.

I am trying to create a unique sample code by putting together the values of other cells that a user will input. It's all working well apart from the last part, where I am trying to include a decimal number. I want the decimal number to appear without the central "." and in a four digit format. e.g. 2.5 would appear as 0250, 14.25 would appear as 1425. This is the formlua I am using currently:

However, where the value of H4 is 2.5, I am getting a result of 0303 (I've put this part in bold). I have attached a small spreadsheet to aid understanding.

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?

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.

I am attempting to convert a spreadsheet of times (listed in the format 06:15:39.62, where 06 is the hour, 15 is the minutes, 39 is the seconds, and .62 is in truncated miliseconds) into fractions of hours (so, 6.25 [NOT 6:25!]). I've so far been doing it manually for each value, which is quite tedious (doing basic division of seconds and minutes into hours, to find the fraction) but I'd like a single formula which I can then apply to the whole spreadsheet.

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"

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?

Is there a way to conver a persons time spent (given in weeks) to adjust/convert to show per month. Attached is the sheet. Do note that week 2/25 - 3/1 is a combination of Jan and Feb so hours should be logically divided into jan and feb...

Name 2/18 - 2/22 2/25 - 3/1 3/4 - 3/8 3/11 - 3/15 Feb mar Tom 40 10 0 20 ?? ?? name 2/18-2/22 2/25 - 3/1 3/4 - 3/8 3/11-3/15 Feb Mar

I'm building a schedule in excel and am having trouble with the calculation of total hours when lapsing a day, or more specific, adding it into my current equation. For example; Monday they clock in at 5pm and work till 1am. I have found a couple of ways to get the desired out come from this on it's own. I just add the value of a day if the out time is less than the in time, or if the out time minus the in time is less than 0.

However, I need to add this calculation into an equation that is already calculating time elapsed within a single day, turning that into a decimal number and then checking if the total time elapsed is less than 6 hours, if false it subtracts a thirty minute break. Here is the current equation I'm using, I'm sure that there is an if(or, or if(and I could use to make it work when the time lapses 12am while also performing the 6 hour check to subtract the break.

i try to convert several decimal values into Days Hours:Minutes:Seconds my problem is the following. If i user the format DD hh:mm:ss values over 32 will start counting the days from 0 (like a new month). and if i format it like M D h:m:s values < 32 days gets displayed with a 1 (for the month) before the days.

[Code] ......

is there a way to get only the count of days displayed without the summarization to months?

I'm trying to find out how many 40 hour shifts we had in a week by dividing the total seconds staffed (2989957) by total seconds in a week (144000) to get a 2 digit decimal result. I have a field formatted as [s] that I need to convert to decimal but when I do a calculation using that field it comes out as [s}.

Cell A1: 2989957 formatted as [s] Cell B2: =A1/144000 formatted as number with 2 decimals Result shows 0.00

If I use that calculation in a cell with a general format, I get 21 and it reverts to [s] format.

Imagine that i have an item entering my warehouse on 22/05/2008 at 21h35 and leaving on the 25/05/2008 at 5h42.

A1= 22/05/2008 and B1= 21h35 A2= 25/05/2008 and B2= 5h42

The goal is to count the full 24 hours day and the remaining hours.

For the example given i can say that on day 22 the item only says 2 hours and 25 minutes, on day 23 it stays 24 hours and on day 24 another 24 hours, on day 25 the item leaves at 5h42, so it only stays those 5h42.

So we have 2 full 24 hour days and 2h25 plus the 5h42, the the item were stored 2 days and 8 hours and 7 minutes.

The problem is when the item arrives at (example) 22/05/2008 2h00 and leaves at 25/05/2008 23h00 on another day. Lets say that on the first day the item is 22 hours stored, plus the 2 full 24 hour day and another 23 hours. So it is 2 days plus the 45 hours, that is 2 days plus 1 day and the remaining 21 hours.

how to add to this 2 full days the 1 day and 21 hours

I have a spreadsheet where I record individual staff start time, end times and the length of their break. From this I caculate the hours they worked for the day.

E holds Start, F holds End and G holds Break length. Thus using the following forumula gives me the number of hours and minutes:

I need to convert the fraction at the beginning of a cells text into the decimal equivelent. for example 1/4-20 3A would give .2500. I have this formula so far that works perfect for fractions that only contain 1 number on each side of the division sign such as 1/2.

Is there a method to automatically convert a decimal to a percentage?

For example:

if given the value of 76.48, is it possible to automatically convert this to 76.48%? Formatting the cell as a percentage produces 7648%. I've tried everything I know and can't get the right result.

I was reading this Binary Conversion from Decimal on this site, however i am unable to reply to the thread. This code is exactly what i was looking for but have the need for it to be able to give the result as a number of bits eg. i would like the result to be dispalyed as 13 bits. I have tried modifying the code without any success and would like to be able to use it in this form. Public Function Dec2Base( Num As Long, base As Long, length as long) As String

I can’t figure out why this formula is not working. I am trying to alter it a little, but I still think it should work. Here is what I am trying to do. I am looking to calculate the time difference between two work projects, but exclude time when the office is closed. So someone starts a project at 2pm and finish 10am the next day it will show a result of 4 hours because the office closes at 5.

Here is the formula. It is the time formula from cpearson.com ...

firstly I did txt to columns, then I found some data changed to scientific format which is not I wanted as I could not convert it using function HEX2DEC.