G Guest May 17, 2004 #1 I'd like to be able to take a total amount of time, such as 4:45, and have it displayed with the minute portion in hundredths of an hour in decimal form. So, 4:45 would be shown as 4.75.
I'd like to be able to take a total amount of time, such as 4:45, and have it displayed with the minute portion in hundredths of an hour in decimal form. So, 4:45 would be shown as 4.75.
P Peo Sjoblom May 17, 2004 #2 Multiply with 24 and format result as general or number -- Regards, Peo Sjoblom BigAl said: I'd like to be able to take a total amount of time, such as 4:45, and have Click to expand... it displayed with the minute portion in hundredths of an hour in decimal form. So, 4:45 would be shown as 4.75.
Multiply with 24 and format result as general or number -- Regards, Peo Sjoblom BigAl said: I'd like to be able to take a total amount of time, such as 4:45, and have Click to expand... it displayed with the minute portion in hundredths of an hour in decimal form. So, 4:45 would be shown as 4.75.
