time format

  1. P

    Format Painter Doesn't Work

    (Using both the latest Excel release (2019?) and libraries with legacy releases) I have some music track time lengths that are in the format 5:43 (h:mm), but another column displays 5:43:00 AM. So I used both the Format, Number, Custom, h:mm option on the cells that showed the AM designation...
  2. K

    Data Validation - 15 Minute Intervals - Time Range

    I have a column of cells in which I need users to input their time spent on a project ( time input as [hh]:mm ) the hours are accumulated over a 6 month period so can exceed 24 hours - but I would like the times entered to be restricted to 15 minute intervals (eg. 60:00, 55:15, 43:30, 38:45...
  3. P

    Convert hh:mm:dd to decimal time

    Hello, I've tried converting the format hh:mm:dd to decimal time and it isn't working. My input data values are coming from a SW program that creates a text output. It is coming in either as general or custom format. Input = 76:41:30 I want my output to be 76.69 I think my problem may lie...
  4. T

    VBA macro - change time format and select rows with specific month

    Hi guys, I have a big file with columns D & E that contains time of starting an action (D) and finishing the action (E). I need the time in a custom format, like: mmmm dd, yyyy hh:mm:ss AM/PM Records are from the last 2 years, but i'm interested in a specific month, let's say, January 2017 and...
  5. A

    Comparing Times in Access

    I'm working on an employee schedule. I have folks start and end times as well as break and lunch times. I'm trying to create 1/0 for working/not working in 15-minute intervals throughout the day. My equation looks to say if the interval is less that the person's start time, greater than the...
  6. S

    Formatting more than a months worth of seconds

    First, let me clarify that I am NOT trying to "convert" seconds to a "# of days, #of hrs, # of mins" ... I am trying to take a cell that has a number of seconds already in it, but I would like it "displayed (formatted) to show "# of days, #of hrs, # of mins". I'm struggling with finding a...
  7. P

    Copy time formatted cell

    Hi Folks I'm trying to join the content of two cells: one of them is in the format 10:40:15, and the other is in the format 11/11/2015. When I try to concatenate the contents of both cells to get something like "11/11/2015 10:40:15", the date field format goes ok, but the one with the time...
  8. M

    Text to Columns Time Issue in Macro

    I have data that is formatted like so... <tbody> calldate 12/12/2015 18:52 12/12/2015 16:50 12/12/2015 16:17 12/12/2015 14:00 12/12/2015 13:44 12/12/2015 13:35 12/12/2015 13:11 </tbody> I'm running a macro, and one part of that macro is to separate the date/time column into...
  9. J

    Time conversion

    Hi there gurus! I'm trying to convert a general entry into a cell into a time format. The general entries are all entered as 06:00am for example. I've tried changing the formatting of the cells but as the data is pulled from a website it continually enters refreshed data as a general format...
  10. Prevost

    check cell value to given number of significant digits

    Hi There. I want to check a cell value to a given number of significant digits. Is there a way to do this using a function? Say if I wanted to check if the value of a cell is pi, but only to two significant digits (so 3.14) is there a function or vba that I can use to check a number and cut off...
  11. Prevost

    Checking to see if time difference is 1 hour using if function

    Hi There. I want to use an if function to determine whether or not the time difference between 2 cells is not equal to 1 hour. I tried =if((A2-A1)=0.0416666666666667, 0,1) but it does not work all the time. For example, 16:00-15:00 is not 0.0416666666666667. I converted the time difference of...
  12. T

    Help me convert a column of times from text, but starting like this (thank you)

    <colgroup><col style="width:48pt" width="64"> </colgroup><tbody> 754 1007 1102 806 </tbody> I've hand tallied a bunch of data (as text format), but to save time, I didn't enter the ":" (notice I didn't say "enter the colon"...wait I just did:warning:)...
  13. B

    Calculation of breaks between workshifts

    Guys please help as I ran out of ideas: I need to calculate workers' rest time between two shifts, example Day 1 Time in: 8:00 Day 1 Time out: 23:00 Day 2 Time in: 8:00 Day 2 Time out: 17:00 Rest between shifts: 9hrs [so formula would be Day 1 Time out - Day 2 Time in, but it never returns...
  14. L

    Problem with export query for time formatted data from Access 2010 to Excel 2010

    Hi, I have an excel .xlsm spreadsheet used for several years that has many ms query connections to an access db. After the company upgraded to Win 7 \ Office 2010 one of the simplest ms queries will not work. This query simply goes out to an access db table which contains one record and 1 field...
  15. N

    Formatting a number string to "time"

    I have a mapping program that uploads data with the date and time but when it exports it the time is converted to just a number string, e.g. 15:12:37 becomes 151237000. Is there way to eliminate the last three zeros and insert a ":" between the second and third, and fourth and fifth characters?
  16. T

    Time format setup

    Hi, I got a big database of phone calls and I'd like to analyze call duration. 000:00:02:10 --- this is the format of the numbers I'm getting, this should be 2 minutes 10 seconds, but I can't really transform it to the right format to be able to use it for creating sums or averages. Any...
  17. S

    Time Format

    I have time in format 7:00 (without AM/PM). How can I format it to proper time format 7:00 AM/PM. I am using excel 2007
  18. B

    Time cell does not add correctly

    Good morning all, I am trying to add the values in cell H73 (see below), but what I get is not correct. In this cell H73, formatted as Time, I have this very simple formula: =H14+H28+H42+H56+H70 <TBODY> G H 68 Total Hrs. worked 9:00 69 Total min. Travel Time 1:00 70 Daily total 10:00...
  19. U

    Adding very large amounts of time together.

    My program has been running for a while until I ran into a very large time from the data it is importing. I though some of the times were large but this one is in a new ball park. "10016:30:32" I admit that is sloppy to declair a varable as varent but I am not sure how to deal with time. This...
  20. M

    Problem exporting time formatted data from Access 2010 to Excel 2010

    Hi all. I'm having a problem exporting an Access 2010 query to Excel. The Access query contains a number of text and numeric fields which export with no issues. However, one of the fields is in a time format ([nn]:ss) which, when exported to Excel, fails to transfer the values. The database...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top