LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 55
Default Working with hours:minutes

Hi folks!

I'm doing some arithmetic that eventually gives me an answer of 19.
Technically that answer is 19 minutes. I need to know how to conver
that to ":19" or "0:19" so that I can properly add it to the 13:00 in
the next column.

Perhaps I'm just sleep-deprived... I have been scouring the internet
but I just can't find the phraseology I need to find the answer.

Many thanks!
Craig
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
calulate working hours and minutes between 2 dates and times nigeo Excel Discussion (Misc queries) 10 August 12th 08 10:08 PM
Converting total minutes into hours and minutes in Excel colette Excel Worksheet Functions 11 December 26th 07 07:24 PM
=SUM(A1:A5)*24 for totalling hours and minutes is not working Calebs Grandma Excel Worksheet Functions 2 November 16th 05 10:21 PM
how to change a decimal number (minutes) into hours and minutes? Erwin Excel Discussion (Misc queries) 2 November 5th 05 04:22 PM
add hours & minutes to other hours & minutes to receive total hou. Wes Excel Worksheet Functions 2 March 1st 05 11:33 PM


All times are GMT +1. The time now is 10:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"