Formula to work out hours worked
 

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
--
Thank you for reading my post. Hopefully you can answer my querie

Formula to work out hours worked
 

=(end_time-start_time)*24

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Shazza" wrote in message
...
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
--
Thank you for reading my post. Hopefully you can answer my querie

Formula to work out hours worked
 

"Bob Phillips" wrote in message
=(end_time-start_time)*24

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

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


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


"Bob Phillips" wrote in message
...
=(end_time-start_time)*24

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Shazza" wrote in message
...
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
--
Thank you for reading my post. Hopefully you can answer my querie

Formula to work out hours worked
 

Also crosses midnight:

=MOD(B1-A1,1)*24

=MOD(endtime-starttime,1)*24

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Chip Pearson" wrote in message
...
"Bob Phillips" wrote in message
=(end_time-start_time)*24

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

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


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


"Bob Phillips" wrote in message
...
=(end_time-start_time)*24

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Shazza" wrote in message
...
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
--
Thank you for reading my post. Hopefully you can answer my querie

Formula to work out hours worked
 

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

"Bob Phillips" wrote:

=(end_time-start_time)*24

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Shazza" wrote in message
...
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
--
Thank you for reading my post. Hopefully you can answer my querie