convert time

  • Thread starter Thread starter gareth
  • Start date Start date
G

gareth

I have 09:30 in cell C35 (which is a value of 0.39583333).

I need to get 09:30 into cell G35 as text.

Any suggestions gratefully received.

Gareth
 
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

compare TIME in IF statement 8
Command line utility for inserting data into Excel spreadsheet 1
"If" formula help 7
Convert time cell 1
undo VBA procedure error when called via change event 8
Deleting blank cells w/o impacting other rows/columns 3
autofilter 1
Finding and working with rows that have data in only 2

Back
Top