Summary: Hope someone can help..2 issues here when my data arrives in Excell I need it to be in HH:MM for time calculations..correct? however my data appears X...
Summary: Hi , I would like to do the substractions from the cells which is in time format. Supporse I have 2 cells. one is Starting time (16:31:44) and the oth...
Summary: How do you calculate time if the time period is typed in one cell. example: Cell A1: 0500 - 1530 Cell B1: 1200 - 1830 Cell C1: 1300 - 2230 My main go...
Summary: Normal calculating time differences is simple a matter of subtracting one from the other, that is providing the fields are defined as Time/Date fields...
Summary: Sorry my Excel macro writing is a bit poor. Most of my spreadsheet work is done in Lotus 123. I was waiting for the other shoe to drop. Is this an i...
Summary: I hate time calculations in Excel. Here's what I tried. A1: 8:11 AM B1: 4:58 PM C1: =(B1-A1)*24-.5 Result: 8.28 Repeat that for 3 more working days. ...
Summary: I am trying to come up with a formula that will take 1/2/2009 6:30:00 PM (column C in Excel for Start Date & Time) and 1/3/2009 9:57:00 PM (column E...
Summary: Hi, Can I ask that you start a new thread. It makes it easier to track topics. Use a title that describes the issue such as Excel time calculation aft...
Summary: Hi, Here is some information on Time in Excel. Times in Excel appear difficult, but if you ensure that all data entry follows a time format that Excel...
Summary: Let me start by saying that I hate time calculations, so there may be a much better way to do this. I hope someone else is following this thread and h...
Summary: Need some assistance in coding a button: Click Open Chemical Asks which chemical (Validates with a list if present) - if not says invalid Ask mfg expi...
Summary: Sorry about the posting - I'm new to this - hope this is more readable Hello 650Pete Times in Excel appear difficult, but if you ensure that all data ...
Summary: In cell A2 I have my start time: eg 5:30 In cell A3 I have my stop time: eg 4:30 What is the formula I need to calculate the time I've worked? ...
Summary: I am using Excel to help me record responses to some performance tests I give. In doing this, I have to record start and stop times, in seconds, then...
Summary: It would be easier if you went to a 24 hour clock. Otherwise you will have to decode the am/pm. Also can the period exceed 12 and/or 24 hours. If y...
Summary: I am trying to create a schedule in EXCEL. I want to post it for associates and I want it to calculate the hours they are scheduled. The problem is th...
Summary: I need to be able to use time in an arithmetic formula. For instance, if a cell has a number representing 45 minutes, I need that calculated as .75(or...
Summary: Hello, I am a self taught Excel user so I apologise if the answer to my query is a simple one. I can do basic things but one simple calculation is el...
Summary: I have an access Db which contains data on system faults - they have a start time and a fix time (which maybe days later) - I can calculate the time i...
Summary: Hi - I need a little help devising something that will basically do the following: I have a set of dates of transmissions and I want to find the time...
Summary: I am creating a spreadsheet which will log my time in and out of my client's offices. I sell blocks of hours to most of my customers and I want them t...
Summary: G'day, I'm not sure if this will solve your problem exactly, but I will email you an excell spreadsheet that I used in a previous contract. I enter th...
Summary: Unfortunately it is normal. The automatic calculation option is set in the instance of the application not in the workbook. When you open your workboo...
Summary: I have a problem calculating time in Excel. For example, in column A the time is 30:20(30 hours and 20 minutes), how can I turn the minutes into hours...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
