Excel - Date/Time formating to text problem

S

sorenwhite

Hi,

Can anyone please help my small problem.

when taking the difference between two time cells I get a time forma
output in minutes, formatting the cell with ( [h]:mm )

However when multiplying this cell, Excel recognises it as the origina
excel real time format not as text.

The output I get is incorrect due to the cell in date format, when
need it in a text format (ie: 120 (minutes) not as 1/1/1900 2:00) i
the cells calculation.

Your help is gratefully appreciated


Sore
 

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

Excel - Date/Time formating to text problem 1
Date Time formatting problem 7
Date Formating Problem 1
Date Formating 2
Date / Time problem 4
Formating time when pasting from PDF to excel? 1
Calculating Dates From Text 3
Formula Bar - display of content 4

Top