Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 1st 05, 04:55 PM posted to microsoft.public.excel.misc
Fernando
 
Posts: n/a
Default How do I convert hh:mm:ss to an absolute number (26:01:32 to 26)?

I am attempting to calculate a duration by subtracting the end date and time
from the beginning date and time, and would like a absolute number returned.

For example: Start=10/25/2005 10:30 End=10/26/2005 12:30 which results in
26:00:00 in time format or 1.08 in number format. I need just 26. Does anyone
have a way to convert either result to an absolute value of 26?

Thanks for the help.


  #2   Report Post  
Old December 1st 05, 05:02 PM posted to microsoft.public.excel.misc
 
Posts: n/a
Default How do I convert hh:mm:ss to an absolute number (26:01:32 to 26)?

I do it with a cell format. In the custom format I use:
[h];@ It trims it down to just the hour.



Reply
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
how do I convert a number to number of years, months and days because Excel Worksheet Functions 2 October 12th 05 06:15 PM
convert dates to number of days milk0s Excel Worksheet Functions 2 September 28th 05 01:31 PM
convert text-format number to number in excel 2000%3f Larry Excel Discussion (Misc queries) 1 July 29th 05 08:18 PM
convert number to word (text) ROHIT Excel Discussion (Misc queries) 3 July 20th 05 01:27 PM
"Convert to Number" option disappearing Mike Excel Discussion (Misc queries) 2 June 10th 05 04:11 PM


All times are GMT +1. The time now is 03:15 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017