Computing time

bailey100

New Member
Joined
Oct 26, 2006
Messages
1
How do you compute hours for a time sheet? That is I worked 11 to 6 one day, 11 to 4:30 the next and so on. How do you do it so it automatically figures the total hours for each day.
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Fawlty1

Board Regular
Joined
Aug 12, 2002
Messages
59
Try this: cell A1 = 11:00 am and cell A2 = 4:30 pm then formula in cell A3 should be =hour(A2-A1)+minute(a2-a1)/60
 

Watch MrExcel Video

Forum statistics

Threads
1,111,910
Messages
5,541,538
Members
410,547
Latest member
htran4
Top