Formula to work out hours worked

S

Shazza

Hi does anyone know a formula that will work how how many hours a person has
worked automatically without my having to count it up on my fingers and
manualy add it into my spreadsheet
 
B

Bob Phillips

=(end_time-start_time)*24

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
C

Chip Pearson

Bob Phillips said:
=(end_time-start_time)*24
Click to expand...

And if it is possible that the times cross midnight, use

=(EndTime-StartTime+(StartTime>EndTime))*24


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
 
S

Shazza

Thank you very much. I have been agonising over that for ages. You have
saved my computers life. :)
 
Top