Time Formulars

[Guest]

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.

 

[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

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.

 

[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