# Time Format Why I Enter Colon Between The Hours And Minutes

Oct 28, 2007
I have used the format [hh]:mm in a cell for 24 hr clock calculations. Why do I have to enter the numbers with a colon when I populate the cells? Is there a way to set it up so I just type in the four numbers and the colon between the hours and minutes populates itself?

View 9 Replies
ADVERTISEMENT
Jan 29, 2010

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

View 9 Replies
View Related
Jul 6, 2007

is there a way in VB to make it fast, and tidy, clear the contents of all unlocked cells on one sheet ?

View 2 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
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
Nov 30, 2003

Is there a way to format cells so 24 hour time may be input without the colon, as an example 1425 instead or 14:25? We can do it in Access. One would think it possible in Excel, yet I have not discover how if indeed its possible.

View 9 Replies
View Related
May 6, 2009

Is there a way to enter a colon into a standard number to create a value that can be formatted into a 24 hour time value? eg a time is listed as 1345 with a general number format, and I want it returned as 13:45 witha custom format of hh:mm. Other than creating a table and using a vlookup function

View 3 Replies
View Related
Oct 15, 2008

Having trouble adding a column of minutes and converting the total into hours and minutes. Say Cell A1 through Cell A18 each have 12 minutes in each cell. I want cell A19 to tell me how many hours and minutes of total time that have elapsed. I have tried hh:mm, [hh]:mm, but nothing works.

View 9 Replies
View Related
Jun 4, 2006

If i have a start time of 5:00 am and a finishing time of 4:25 pm, what function do i use to get the total time of 11 hours & 25 minutes?

View 10 Replies
View Related
Dec 10, 2008

Just basic enter a start time in column A a finish time in column B and column C gives you total in hours and minutes and then maybe a way to sum those hours and minutes. how to do "Math" on time and how it should be entered (formatted) for it to work properly.

View 4 Replies
View Related
Feb 27, 2012

If I want to make a formula for a time such as

I have this time like 4:30 hour and i want to get this time by minutes like 270 minutes.

View 1 Replies
View Related
Feb 1, 2010

I've got a worksheet that deals with dates and time. Similar to a checkbook, I need to take the balance and subtract what's taken from that. But the writer copied this from another software program and it's in this format. How do I convert it to a time format? Or is that what I really need? Right now the taken and balance are both in a general format.

I just need to know on any of the given days what the balance of this person's time was in hours and minutes.

View 2 Replies
View Related
Oct 13, 2012

i need a vba code , i have time in column F like 8:30 , 3:30 , 5:30 , 8:30 , 9:30.......i need a macro which will add 00:30 in all cells in column F if time is less than 7.00 hrs

View 3 Replies
View Related
Mar 3, 2013

The attached file contains data. In Worksheet 1 (and also 2 and 3) column B2 shows day, month, year, hours, minutes and seconds. I was hoping to convert this to just Hours and Minutes, but all the usual methods using Custom Format does not work. This leads me to think that its in TEXT format. How can I change Column B2 to Hours and Minutes?

View 14 Replies
View Related
Jun 15, 2014

basically I am trying to make a time calculator for work, I want it to automatically add the hours up but then also minus break times and then give me a whole paid total hours worked that week.

CALCULATOR.xlsx

View 1 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
Sep 14, 2007

if someone called me at 4:55pm and ended the call at 5:10pm, the whole call lasted 15 minutes. So, I want to show on excel that the call lasted 5 minutes in the 16th hour of the day (4:55pm) and 10 minutes in the 17th hour of the day (5:10pm), for a total of 15 minutes.

View 3 Replies
View Related
Oct 5, 2007

I have been trying to write a formula to calculate the differrence in days, hours or minutes between 2 cells in Excel.

Here is an example of the two cells

06/08/2011 00:0006/08/2011 12:19

View 5 Replies
View Related
Apr 24, 2008

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:

task 1 54:00:00

task 2 20:45:00

task 3 27:05:20

task 4 51:10:45

total 153:01:05

How many days, hours and minutes?

View 6 Replies
View Related
Aug 22, 2012

I have

Code:

Start date 21/08/2012 23:21:30

End Date 24/08/2012 22:21:45

is there a formula to get the time difference in Hours for example in this case its 72:01:15 72 Hours, 1 minute & 15 seconds

View 2 Replies
View Related
Jul 20, 2007

I want a forumal to do in excel.

Assuming that a workday is from 8:30am to 5:00pm. (also need to not calcualte Saturday and Sunday but this example doesn't show it).

Wednesday, 7/18/07 at 4:00pm (minus) Friday, 7/20/07 at 9:00am (should equal) 10 hours or 1 day, 1 hour and 30 minutes.

Basically what I want to do it determine how much work time has elapsed from the time a message was left on voicemail to the time that someone picks that message up. We only want to assume that a message can be retrieved duruing business hours but a message can be left at anytime!

View 10 Replies
View Related
Oct 13, 2007

How can I work out the following in hours an minutes: -

Cell A1 = 12th May 2007 20:00

Cell B1 - 14th May 2007 14:30

or should I put the dates and times in seperate cells? I would like the answer to show 42 hours 30 minutes

View 3 Replies
View Related
Oct 14, 2009

Im trying to figure out the formula to comput hours:minutes between time on different dates a couple of days apart.

B12 = Date

B15 = Time (on date in B12)

Previous date and time are in AA9. I have been trying to us =SUM(B12+B15)-(AA9).

View 5 Replies
View Related
Oct 15, 2009

How can I format cells to contain Minutes, Seconds and Hundredths of seconds to be used in calculations eg 1.24.99 means 1 minute and 24.99 seconds. Example calculation is: 1.24.99 - 1.24.90 =0.0.09

View 2 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
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
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
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