Remember Me?

#1
December 1st 05, 04:55 PM posted to microsoft.public.excel.misc
 Fernando Posts: n/a
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
December 1st 05, 05:02 PM posted to microsoft.public.excel.misc
 Posts: n/a
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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post because Excel Worksheet Functions 2 October 12th 05 06:15 PM milk0s Excel Worksheet Functions 2 September 28th 05 01:31 PM Larry Excel Discussion (Misc queries) 1 July 29th 05 08:18 PM ROHIT Excel Discussion (Misc queries) 3 July 20th 05 01:27 PM Mike Excel Discussion (Misc queries) 2 June 10th 05 04:11 PM

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