calculating hours

  1. D

    Calculating hours between selected cell entries in regards to a certain cell

    I have cells with the following, Day/Month/Year/Time/Timezone, format: 15. March 2018 13:18:42 CET I would like to chose a certain cell, mark it as t0 (by putting 0 as value or checking a box or something) and then having Excel calculate the time difference for other cells (in hours, rounded...
  2. A

    calculating time formulas

    I am working on a spreadsheet and having trouble with the formulas to calculate the times for each of the columns. I would like to be able to enter the times and have it calculate the rest. I am so frustrated and there has to be an easier way.:confused: thanks so much. <tbody> Date time...
  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...