Time Keeping

  • Thread starter Thread starter Jim L
  • Start date Start date
J

Jim L

I have a spreadsheet which has two columns formatted as
time fields. One is a start time, the other an end
time. I want a third column which represents the hours
worked (end time - start time).

How can I subtract the time and get this value?
 
Jim,

Here is what I am using
This is the totals minutes I113
=MINUTE(SUM(F113:F117))+(HOUR((SUM(F113:F117)))*60)
This will give the hours and minutes in decimal form =(I113*(1/60)), you can
then multiply by per hour.

Wayne B
 
Back
Top