Entering Mutliple times in a cell

G

gary66

Hi all,

I am trying to enter multiple times in a cell.
eg. in a cell I want to enter, say.. 9:35 + 1:50 + 1:15.
These times are for hours worked in a day.
The 9:35 is normal time, the 1:50 is time and a hal and the 1:15 i
double time.
I would like that same cell to be able to calculate the total tim
which is: 12:40.
Is this at all possible??
:confused
 
M

Max

Perhaps consider inputting into multiple cells instead,
and then just use SUM() to total up

Example:

Input in
A1: 9:35
B1: 1:50
C1: 1:15

Then just put in D1: =SUM(A1:C1)

Format D1 as Custom, Type: [h]:mm
(this will allow the hours part
to accumulate beyond 24 hours)

Just copy D1 down to add-up similar entries in row2, row3, etc
 
A

Arvi Laanemets

Hi

Even better - enter start and end times into 2 columns, and let Excel
calculate all time intervals (+ overwork) in separate columns automatically.
How to do it, depends on definitions for different time types (and on
overwork's definition, and also on rules for lunchtime, when needed).


--
Arvi Laanemets
(When sending e-mail, use address arvil<At>tarkon.ee)



Max said:
Perhaps consider inputting into multiple cells instead,
and then just use SUM() to total up

Example:

Input in
A1: 9:35
B1: 1:50
C1: 1:15

Then just put in D1: =SUM(A1:C1)

Format D1 as Custom, Type: [h]:mm
(this will allow the hours part
to accumulate beyond 24 hours)

Just copy D1 down to add-up similar entries in row2, row3, etc
Click to expand...
 
Top