numbers to time

  • Thread starter Thread starter Jibba02
  • Start date Start date
J

Jibba02

how do i convert numbers into time format

eg. i would like to convert a number from cell 1B into time format in cell
1A.
so if i typed 90 into 1B it would automaticly display 0.01.30.
90seconds equals 1minute and 30 seconds


Cheers
Tim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count function without double counting 1
countdown timer 2
Using a function/formula for copying text 6
How to calculate with formula results after formatting with =TEXT 3
How to add time from multiple cells & date Cells & machine type c 3
Formula Based On a Check Box 2
If statements and conditions - again!! new prob 2
Pivot table - display all labels (i.e: do not summarise) how to? 1

Back
Top