calculating time

  1. S

    Calculating Time Units - VBA User Form

    I have code that will calculate time elapsed and how many 15 minute units are between the two times entered. It was later decided that an user form may be the more appropriate approach for my audience but I have 0 experience with user forms. I made an attempt but I can't figure out how to make...
  2. O

    Calculating time from 2 columns

    Hi, I have two columns like this way. <tbody> a 102 103 a 135 136 a 157 160 b 189 191 b 201 202 a 222 223 a 245 250 b 290 292 </tbody> Here the values are in seconds. I want to write a formula, which show the total duration of seconds of a and b. For example: here total...
  3. E

    Calculating Time

    I have a spreadsheet detailing employee time swipes through a card reader. Unfortunately, all of the time data is in a single column. What is the easiest way to calculate hours worked per day? I'm looking at all data for all employees from January 2011 through February 2011, so it's a large set...
  4. W

    Difference Between two dates and times

    Aloha, I have A1= Date A, B1 = Time A, C1 = Date B, D1 = Time B, E1 = Hours between Date&Time B and Date&Time A how can I enter a formula that takes the date and times from separate columns and calculates them? Mahalo in advance!

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...