Time Formulars

D

Dawn

Can someone please tell me , is there a formular , for calculated hours worked
eg: i use one column for start times , one for finished times , and I would like the third column to caculate the hours inbetween , Start 9:00:00am - Finish 2:30:00pm - Hours Worked 5.5 - Any help would be gratefully recieved.
 
C

Chip Pearson

Dawn,

Use something like

=(End_Time - Start_Time)*24

If it is possible that the duration will cross midnight (e.g., start at
10PM,end at 2AM), use a formula like

=(End_Time - Start_Time + (Start_Time<End_Time))*24


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

Dawn said:
Can someone please tell me , is there a formular , for calculated hours worked?
eg: i use one column for start times , one for finished times , and I
Click to expand...
would like the third column to caculate the hours inbetween , Start
9:00:00am - Finish 2:30:00pm - Hours Worked 5.5 - Any help would be
gratefully recieved.
 
F

Frank Kabel

Hi
one way (if A1 stores the start time and B1 the end time9:
=(B1-A1)*24

or if your working time can span midnight:
=(B1-A1+(B1<A1))*24
 
Top