converting time values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how can i convert a time value, eg 1:30:34 to just minutes, eg 90minutes 34
seconds.
 
Apply custom cell format [mm]:ss

Regards,
Stefi


„redtool_man†ezt írta:
 
Thanks Steffi, you're a star, I'll buy you a drink when I see you.

Stefi said:
Apply custom cell format [mm]:ss

Regards,
Stefi


„redtool_man†ezt írta:
how can i convert a time value, eg 1:30:34 to just minutes, eg 90minutes 34
seconds.
Click to expand...
Click to expand...
 
You are welcome! I like Irish whiskey!

Regards,
Stefi


„redtool_man†ezt írta:
Thanks Steffi, you're a star, I'll buy you a drink when I see you.

Stefi said:
Apply custom cell format [mm]:ss

Regards,
Stefi


„redtool_man†ezt írta:
how can i convert a time value, eg 1:30:34 to just minutes, eg 90minutes 34
seconds.
Click to expand...
Click to expand...
Click to expand...
 
You must log in or register to reply here.

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

figuring total time 1
Adding time values 4
Subtract times? 2
Look up two values in different columns and return matching value 5
please help.is it possible re-edit macro to convert text like1530-2200 to time format automatically? 1
Formatting cells with time 3
day of the week and date formula 2
formula for adding time to time eg 90min to 6.30am 4

Back
Top