| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time format - problems with calculation
I am trying to make a sheet were I can calculate the amount of hours from
start to finish. In A1 I put in the start time 08:00 In A2 I put in the end time 16:00 In A3 I put in a formula =A2-A1 and the anwer that is returned is 08:00 (8 hours). When I try to mulitply the result A3 (08:00) with a timely rate of 200 the result is wrong. And when I try to format the result 08:00 into normal standard number - the number is set to 0,333333 How can I make Excel undertand that the time from 08:00 to 16:00 should be 8 (hours) so I can use this in caluculations?? Kathrine |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time format - problems with calculation
Hi
=A3*24*TimelyRate -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "Kathrine" wrote in message ... I am trying to make a sheet were I can calculate the amount of hours from start to finish. In A1 I put in the start time 08:00 In A2 I put in the end time 16:00 In A3 I put in a formula =A2-A1 and the anwer that is returned is 08:00 (8 hours). When I try to mulitply the result A3 (08:00) with a timely rate of 200 the result is wrong. And when I try to format the result 08:00 into normal standard number - the number is set to 0,333333 How can I make Excel undertand that the time from 08:00 to 16:00 should be 8 (hours) so I can use this in caluculations?? Kathrine |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Format | Excel Worksheet Functions | |||
| measure calculation time for multiplication of two matrices | Excel Worksheet Functions | |||
| Problems with time format in excel | Excel Worksheet Functions | |||
| Excel should format time down to the hundredth/sec. | Excel Discussion (Misc queries) | |||
| entering numbers to display a time format | Excel Discussion (Misc queries) | |||
Linear Mode
