Using times

  • Thread starter Thread starter craigwojo
  • Start date Start date
C

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
 
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
 
Is it not just...

=A1*B1

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

[h]:mm:ss
 
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)
 
Back
Top