Formula to calculate time
I have the hours worked in Column A (i.e., 8:00 - 5:00) and the total hours
in Column B (8.0). Is there a formula for Column B that will calculate that for me, or will I have to use two columns for the hours worked (start time and end time) AND use military time in order to do a simple math function formula? Thanks for your help! |
Formula to calculate time
Use 2 columns, one with start and one with end time, then use
for instance start in A, end in B and total in C =B2-A2 will give you the hours unless you need to deduct lunch as well Then you can just total all hours like =SUM(C2:C6) for a week use custom format [hh]:mm to display hours greater than 24 -- Regards, Peo Sjoblom "Helen" wrote in message ... I have the hours worked in Column A (i.e., 8:00 - 5:00) and the total hours in Column B (8.0). Is there a formula for Column B that will calculate that for me, or will I have to use two columns for the hours worked (start time and end time) AND use military time in order to do a simple math function formula? Thanks for your help! |
All times are GMT +1. The time now is 08:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com