Convert
You snipped from my message the part where the OP realised that his 3:37 was
wrong and that he wanted 2:58.
" aghhh...I just figured that out, thank you. How do I take the single
cell
and transfer it into Hours in one cell and minutes in the other for 2.58??
Again, thank you for your help. We have a time sheet that doesn't export
it
into hours and minutes.
--
Dallas
"jhyatt" wrote:
where is 2.97 coming from decimel time time would put that at 2 hours 58
mins"
--
David Biddulph
"Ron Rosenfeld" wrote in message
...
On Tue, 18 Sep 2007 08:08:32 +0100, "David Biddulph" <groups [at]
biddulph.org.uk wrote:
=INT(A1) for the hours
=MOD(A1,1)*60 for the minutes.
That does not give what the OP requested:
OP 2.97-- 3hrs 37 min
DB 2.97-- 2hrs 58.2 min
--ron
|