Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

TIME format conversion

Former Member
0 Likes
1,217

Hi

Please help me out

I have data

Input = 2.00+e4 ( Exponential Form)

i want out put = 20:00:00 ( time format)

how to do this? any function module ???

regards

aryan

6 REPLIES 6
Read only

Former Member
0 Likes
862

Hello,

If you know exactly how it'll always come in - why not use string manipulation?

Kind regards

Ash Thomas

Sap Consultants

www.ashpeople.com

Read only

Former Member
0 Likes
862

Make a type as sy-uzeit Amit.

Read only

Former Member
0 Likes
862

hi

if i give

input 4.00+e4

what will be desired output

can explain it more

with Example

Cheers

Snehi

Read only

0 Likes
862

Hi

I just want to know that

If you check CAWN table ther time format is storing as Float ...and i have to fetch the same field in TIME format

I don't know how....

STRING manupulation i can't do in 2000+e4 format...

any solution...

Read only

former_member195383
Active Contributor
0 Likes
862

This message was moderated.

Read only

Former Member
0 Likes
862

Hi,

When we assign a floating point number to a field of type T

then the floating point number is converted into Packed number (As no. of Seconds) and then the Packed number is converted to time format(HH:MM:SS).

data:

w_float type f,

w_time like sy-uzeit.

w_float = '2.00+e4' .

w_time = w_float.

write w_time.

output :

00:00:02.

I think this will help you