datetime calculation HELP !!!!

  • Thread starter Thread starter steve
  • Start date Start date
S

steve

I get data that is mm/dd/yy hh:mm:ss. I need to figure the
hours between two dates and times (like a begin date and
end date)to see how many hours were spent performing a
task.
 
=A1-A2 where A1 holds end and A2 start, custom format
[h]:mm to make hours roll over 24
 
to get the hours & the sum of in a column =HOUR((SUM(F118:F122)))
to get the hours & the sum of in a column =MINUTE((SUM(F118:F122)))
puttting it together for totals minutes
=MINUTE(SUM(F118:F122))+(HOUR((SUM(F118:F122)))*60)

This will give the totals hours & minutes in decimal for =(I118*(1/60)) that
you can use to find the amount in dollars
NOTE: replace the column/row numbers with yours.

Wayne B
 
Back
Top