Caluulating times and hours

[Guest]

Can any one help me to calculate time and hours
Ex: During a day I have a number of start and stop times that shall be added to total hours. (That is OK
My problems comes when I like to add all the total hours ie; add daily hrs to get total hrs in a week, I need also to be able to calculate negative hrs
Time 1 + Time 2 = Hours
Ex: Monday 09:00-11:00 14:00-15:00 = 03:00 How to add hrs for to get ie: 50:20 hrs in one week?

 

[Dave R.]

You can go to Options and check "1904 date system" to have negatives next to
times.

The calculation of time differences depends on exactly how the data is layed
out. Best if it's layed out with each number in its own cell, rather than
"9:00-11:00" in one cell.

When would you have negative hours in a timesheet?

If the start time is in A1 and end time in B1 (or vice versa), you can use
something like ABS(A1-B1)*24 to get the number of hours between start time
and end time.

Can any one help me to calculate time and hours.
Ex: During a day I have a number of start and stop times that shall be

added to total hours. (That is OK)

My problems comes when I like to add all the total hours ie; add daily hrs

to get total hrs in a week, I need also to be able to calculate negative
hrs.

Time 1 + Time 2 = Hours
Ex: Monday 09:00-11:00 14:00-15:00 = 03:00 How to add hrs for to

get ie: 50:20 hrs in one week?

 

[Norman Harker]

Hi PeO!

For your totalling problem:

Calculate as normal but use custom format [hh]:mm

The [ ] around hh stops the time calculation rolling over to another
day.

For calculations that might result in a negative then you can use the
1904 date system but only with caution because it may well affect
other calculations.

For time calculations generally see:

Chip Pearson:
http://www.cpearson.com/excel/datetime.htm#AddingDates

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.