Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Work out overtime hours for individuals | New Users to Excel | |||
Work out overtime hours for individuals | New Users to Excel | |||
Time sheets | Excel Worksheet Functions | |||
comparing a value in a cell to see if it is higher than a number | Excel Worksheet Functions | |||
Sumproduct help needed! | Excel Worksheet Functions |