Using times

[craigwojo]

Hi everyone,

Still new but learning. How does someone use a formula for figurin
time.

Example:

Column A: # of Tags (input)
Column B: Time per tag
Coulmn C: (formula) Column A * Column B = The totasl time it would b
to make x amount of tags.

I've tried playing around with it but just not getting what I need.

The format should be HH:MM:SS.

Any input will be appreciated.

Thank you,
Crai

 

[Frank Kabel]

Hi
in A1 put your number
B1: time in the format hh:mm:ss
C1 the formula
=A1*B1
AND format C1 with the custom format
[hh]:mm

 

[Aladin Akyurek]

Is it not just...

=A1*B1

with the formula cell custom formatted [ Format|Cells ] as

[h]:mm:ss

 

[Peo Sjoblom]

You need to explain better what doesn't work, it works fine for me if I put
in a time and divide it by an integer (# tags)
For instance 3:05 divided by 7 tags would give 00:26:26 per tag

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)