time formula

[gazebo]

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.

 

[Sandy Mann]

E.Q.,

I think that you mean 6 minutes not 5 minutes:

=(B2-B1)/Time(0,6,0)


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Teethless mama]

=(B1-A1)*240