| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Convert time into integer
how can i convert time into integer, like i m working on a overtime sheet
where i need to calculate the time difference and then multiply with they amount per hour (an integer) to calculate the actual amount of working. |
|
#2
|
|||
|
|||
|
Convert time into integer
Hi Ali
Time is store by Excel as fractions of a day. Multiply your hours*24 to convert them to decimal hours, then multiply that by the rate per hour. Regards Roger Govier Ali wrote: how can i convert time into integer, like i m working on a overtime sheet where i need to calculate the time difference and then multiply with they amount per hour (an integer) to calculate the actual amount of working. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting with time values | Excel Discussion (Misc queries) | |||
| How do I convert time (2:30) to a number (2.5) in a formula? | Excel Worksheet Functions | |||
| convert number to time format? | Excel Discussion (Misc queries) | |||
| Convert date to length of time in months from set date | Excel Worksheet Functions | |||
| In Excel how can you convert a cell formatted for time (4:30) to . | Excel Worksheet Functions | |||
Linear Mode
