Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
time formula
i am a complete dunderhead with excel and need a fairly easy formula for work
out a formula for work. i need to be able to input a start and finish time where 6 minutes = 1 unit of time eg 2 units is 12 mins if i start a job at 12.00 pm and finish at 1230 pm how many units used needs to be displayed. thanks in advance. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
time formula
=(B1-A1)*240
"gazebo" wrote: i am a complete dunderhead with excel and need a fairly easy formula for work out a formula for work. i need to be able to input a start and finish time where 6 minutes = 1 unit of time eg 2 units is 12 mins if i start a job at 12.00 pm and finish at 1230 pm how many units used needs to be displayed. thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
template or formula for start time -finish time -total hours ple | New Users to Excel | |||
Help with time formula so the time will not change. | Excel Discussion (Misc queries) | |||
Time Formula | Excel Discussion (Misc queries) | |||
How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
Time / Formula to look at time difference | Excel Worksheet Functions |