Overlaping Hours

S

scotty

is there any way to calculate time over multipe days?? Or
less than a day? So that whena date changes it adds 24
hours to your 24, and so that it adds the total number of
hours correctly at the end of the month. Someone who is
good with excel please e-mail so I can explain better.

scott
 
N

Norman Harker

Hi Scotty!

Just include the date component in your times.

A1
23-Jun-2004 10:00
B1
27-Jun-2004 18:30

=B1-A1
Format [hh]:mm
Returns: 104:30
 
G

Guest

Hey Norm

I tried doing exactly what you said and it still didn't
work. I get a value error and I've tried to correct it
several different ways and it isn't working. Do you have
any other suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate Total Hours when Overlapping Occurs 0
TIME CALCULATION 8
Formula for calculating target hours against actual hours 12
Adding Days and Hours 8
How to calculate difference between two date & time along with working hours and days 2
Calculating hours 1
calculate time elapsed inbetween days 3
Adding Hours Worked Correctly 4

Top