# calculating hours

1. ### 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. ### 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. ### 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. ### 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!

### 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...