# Tagged Questions

20 views

### Excel convert [h]:mm:ss to a decimal format

I have this cell with an [h]:mm:ss format, and would like to have minutes only, with 2 decimals after the coma (and not seconds). For example: A1: 2551:26:38 becomes B1: 153086,63 How do I do ...
50 views

### Excel function for calculating total spent time

I have an excel sheet, where in some columns I have cells of the type "integer,integerM" or "integer,integerH", for instance "1,30m" or "5,2H". For all the column I would like to get an expression ...
31 views

### Excel multiply days and hours with a factor

I would like to calculate the time span betweeen two dates with excel and multiply the amount of days with a factor - like 2 d and 10 h * 5\$ Its easy to get the days and hours by just substracting ...
42 views

### Sum the number of hours in Excel

I want to sum the total hours I was worked in a project. For each day, I have: Starting Time B1: 09:30:00 am Ending Time C1: 17:00:00 pm Total Hours D1: =C1-B1 (06:30) I want to sum the values ...
84 views

### Avg times in mm:ss.0 format

I have a range of times formatted as mm:ss.0. The problem is trying to average these times. Time AVG 2:44.35 2:42.88 2:47.49 2:48.86 2:56.31 00:00.0
223 views

### How to convert unit of time to Centiseconds in Excel?

I am working with Excel and I need to convert a time unit like this mm:ss.00 (centiseconds) all to centiseconds. There are some formulas to extract Minutes and Seconds from this format but I dont ...
174 views

### How to extract the time HH: MM of a cell stored as "dd/mm/yyyy hh:mm format in excel?

I.E. 01/07/2011 09:30 I would like to extract 09:30 of this cell. How I can do it
517 views

### Calculating Time Difference in hh:mm:ss format

I have time format of hh:mm:ss in one cell and the same formatted time in other cell . I calculate the difference of these two cell and get hh:mm:00 as my difference. What I request if someone can ...
108 views

### How to get Excel to save date fields as displayed.

I have data that has date-time values that I need to convert to a different format. I have created an Excel formula that concatenates the string into exactly the format I need. I currently have the ...
299 views

### Excel Concatenate Time

I have had a look at this site, and across the net, but can't seem to solve this, which should be easy! Concatenate should work, but I wasn't able to make it work. Current spreadsheet looks like ...
51 views

### Excel creating weird diagrams

I have a list of times in one column. They are formatted as Time cells. When I simply select the values and click Insert -> Line (diagram), I can't seem to get the right kind of diagram. What ...
3k views

### Calculating time in Excel between AM and PM

I have an Excel spreadsheet that calculates the difference between two times. The formula that I'm using, for example, is as follows: Cell A1 12:00 PM Cell B1 12:30 PM Cell C1 =minute(B1-A1) and the ...
991 views

### Time units and automatic formatting of the y-axis in Excel

I have a chart with time values on the vertical (Y) axis. As the values can change a lot the formatting of the axis minor and major units is automatic. The problem is that Excel chooses values which ...
389 views

### What format can I use in Excel to display both date and time in system formats

I need to display both date and time in system date and time formats. I know that [\$-0xf800] means the system long date format and [\$-0xf400] means the system time format, but [\$-0xf800][\$-0xf400] ...
3k views

### Calculating a duration in excel from date and time

I have 2 columns in excel, each column includes a date and a time in the following format: 'dd/mm/yyyy hh:mm'. One is a start date/time, the other is an end date/time. The end date/time could be ...
131 views

### Conditional Static Time Entry in Excel

I need to insert a STATIC time into excel based on a condition in a cell. i.e. Cell A1 = "A" then insert the static time. Any ideas?
265 views

### Dynamic time in Excel spreadsheet column

I am trying to automate time in Excel. I have two columns that show time advancing in minutes and seconds. I want to be able to automate so that if the time changes in one row, it will automatically ...
254 views

### Converting a travel time to an Excel time

I have calculated the time it takes to travel from point A to point B. The results are in number of seconds. I have converted the number of seconds to Hours, Minutes, and Seconds in three cells. I ...
66 views

### How do I convert text into time data?

I have text in one column that has times formatted as "1230 pm" and need to convert it to time. I managed to convert the "am" data but didn't get it to work with the "pm" data.
181 views

### Minute:Second to seconds in Excel

I'm trying to work out how many seconds there are in a given time range. So for instance if I have the following times: 16:36:00 - 16:37:38 I need to the value of 98 seconds to be placed within a ...
314 views

### Convert “Mon Aug 01 09:08:25 CDT 2011” to a usable date/time using Excel

I have a giant spreadsheet with computer names and the date stamp that they last reported into our PGP server that I need to convert to a usable date/time, so I can sort the column by the time the ...
3k views

### How to add time duration column total from Skype Call History CSV file in Excel 2010?

How to add time duration column total from Skype Call History CSV file in Excel 2010? These are my exact steps on how to set up my Excel spreadsheet. How to import Skype Call History CVS in Excel ...
3k views

### Excel: convert text string to date/time format

I have a column with date/time info in following format stored as text: 03.01.2011 09:55. How can I convert it to Date/Time format?
979 views

### Excel 2003: convert a numeric cell into time for calculations

I have some data in excel, all numeric, like: 9.00 10.35 19.10 I need to do calculations like: I got at work at 9.00, I got out at 10:00 = I've worked 1 hour How can I achieve this if all my ...
621 views

### Excel: Convert and replace time to seconds

I have a large number of cells that contain time duration in the form: 41m 9s How do I convert the duration into seconds, and then replace the old value of the cell with the converted value ? I ...
4k views

### Work with hours and minutes in Excel 2007

I'm working on a spreadsheet that holds phone calls durations. So, each call (row) has a value like 00:01:30, 01:02:12, etc. When I sum the duration column, it will give me something like 687:23:42. ...
20k views

### How to calculate hours and minutes between two time periods?

I’m working on a very simple time sheet for my work in Excel 2007, but I have run into trouble about calculate the hours and minutes between two time periods. I have a field: timestart which could be ...
22k views

### How to get time difference as minutes in Excel?

I have time values in two cells in an Excel sheet and I need the difference of the times in minutes. The cells in the Excel are like below: A B C 1 6:38 8:23 1:45:00 A is ...