Time to number value

  • Thread starter Thread starter Dessie
  • Start date Start date
D

Dessie

I need to apply a money value to a set of hours worked.
I know the jobs starts at 0800 hrs and ends at 1730 hrs.
Thus I need to find the difference and multiply that by a
money value.
The problem is when I subtract 0800 from 1730 i get an
answer of 8.30 when I am looking for a value of 8.5. How
can i acheive this..
Dessie
 
Hi

You need to multiply it by 24 (hours in a day) as time is stored as a
fraction of 1 day.
 
First convert the time difference into text using
=TEXT(C3-B3,"h:mm"). The result of this would be say for example 2:30
Now, use the formula =(D3-INT(D3))*24 to convert the the resultin
time into decimal format. The result for the above exaple would be 2.5


See the excel attachment for clear understanding.

- Suren Da

Attachment filename: book1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=58372
 
Back
Top