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...
    • atozcleric
    • Thread
    • calculate calculating hours formulas not working spreadsheet time
    • Replies: 5
    • Forum: Excel Questions
  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...
    • erric
    • Thread
    • calculating calculating hours calculating time hours
    • Replies: 5
    • Forum: Excel Questions
  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

Top